Re: crosstab query filtered by form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mj (anonymous_at_discussions.microsoft.com)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 10:13:22 -0700

I think I understand. It looks like this author uses a
placeholder "~" so that something is stored under each
column heading which, in my case, would be under the
products listed across the top of my report. Then, the
author uses the GetPart function to extract the relevant
data point and ignore the placeholder "~". If I'm way off,
please let me know. Thanks for the help on this. I greatly
appreciate it!

>-----Original Message-----
>One of the crosstab reports at
>http://www.invisibleinc.com/divFiles.cfm?divDivID=4 does
this.
>
>--
>Duane Hookom
>MS Access MVP
>
>
>"mj" <anonymous@discussions.microsoft.com> wrote in
message
>news:2f31b01c46bff$84964690$a301280a@phx.gbl...
>> ahh, I see. I have products listed across the top of the
>> report, our company's regions down the side. Problem is
>> that some of the regions don't sell all of the products,
>> so when I filter by a region that doesn't sell all the
>> products, the report will look for a product in the
query
>> and can't find it. hmm. I guess i have to figure out
some
>> way to include all products in the query even if they're
>> not sold...
>>
>> >-----Original Message-----
>> >You probably have something in your report that doesn't
>> match your query. I
>> >can't see your report so I don't know what it is.
>> >
>> >--
>> >Duane Hookom
>> >MS Access MVP
>> >
>> >
>> >"mj" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:2ef7701c46b81$e3306790$a301280a@phx.gbl...
>> >> by the way, the query runs find using your suggestion
>> but
>> >> when i run a report based on the query, that's when i
>> get
>> >> the error...
>> >>
>> >>
>> >> >-----Original Message-----
>> >> >Open your crosstab in design view and menu select
>> >> Query|Parameters and enter
>> >> >your parameters and data types like:
>> >> >Forms!frmDates!txtStart Date/Time
>> >> >Forms!frmDates!txtEnd Date/Time
>> >> >
>> >> >--
>> >> >Duane Hookom
>> >> >MS Access MVP
>> >> >--
>> >> >
>> >> >"mj" <anonymous@discussions.microsoft.com> wrote in
>> >> message
>> >> >news:2d9c801c46b50$c8ac0950$a601280a@phx.gbl...
>> >> >> hi. i have a report that has a crosstab query as a
>> >> source.
>> >> >> i was hoping to filter the report by form buy i'm
>> >> getting
>> >> >> an error saying that i can't do so. is there a way
>> to
>> >> >> filter crosstab queries by form? thanks!
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: crosstab query filtered by form
    ... ahh, I see. ... report, our company's regions down the side. ... that some of the regions don't sell all of the products, ... the report will look for a product in the query ...
    (microsoft.public.access.queries)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)