RE: Set Up Query To Look Like A Pivot Table

From: FrankTimJr (FrankTimJr_at_discussions.microsoft.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 07:21:04 -0800

I was trying to avoid having to create 12 different queries. Actually, it's
more like 108 queries. I have to report the revenue for 9 different
organizations in the company and there is a field in the database that
identifies the "Area". I'd have to create one query per Area per Month.

If this is the only way to accomplish it, then I guess I better get cracking!

Thanks,
Frank

"anonymous@discussions.microsoft.com" wrote:

> hi.
> queries within queries.
> make a query that selects january revenue(direct and
> indirect)
> make a query that selects feburary revenue(direct and
> indirect)
> make a third(master)query that uses the first 2 querys as
> record sources.
> drag january revenues from the january query into it and
> feburary revenues from the febuary queries.
> i use this technique to create running balances by month
> for our inventory. each query selects po's or wo's and
> sums them for the month. the queries get the dates for a
> special form i created.
>
> >-----Original Message-----
> >I'd like to set up a query that looks like a Pivot Table,
> but it not acutally
> >a Pivot Table.
> >
> >I'm trying to report the Sales activities over the months
> of the year.
> >There are two fields that represent the Revenue (one
> field per Revenue Type
> >(DIRECT and INDIRECT)). How do I, or can I set up a
> query that will display
> >January Revenue for both Direct and Indirect in the first
> two columns, then
> >the next two columns, show the revenue for Direct and
> Indirect for Feburary,
> >and so on...?
> >.
> >
>