Re: crosstab query filtered by form
From: mj (anonymous_at_discussions.microsoft.com)
Date: 07/18/04
- Next message: Ed Finley: "Has to be an easier way"
- Previous message: LMS: "Re: query to count multiple records as one?"
- In reply to: Duane Hookom: "Re: crosstab query filtered by form"
- Next in thread: Duane Hookom: "Re: crosstab query filtered by form"
- Reply: Duane Hookom: "Re: crosstab query filtered by form"
- Messages sorted by: [ date ] [ thread ]
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!
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Ed Finley: "Has to be an easier way"
- Previous message: LMS: "Re: query to count multiple records as one?"
- In reply to: Duane Hookom: "Re: crosstab query filtered by form"
- Next in thread: Duane Hookom: "Re: crosstab query filtered by form"
- Reply: Duane Hookom: "Re: crosstab query filtered by form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
