J
John M
Hello,
I am a beginner and have set up the following simple table:
Date Product Sales Cost
Jan03 Widget 100 50
Feb03 Widget 200 100
Mar03 Widget 300 150
Date is my primary key. I want to be able to develop a query or report that
will show the months across the page in columns, and a separate sales and
cost row for each widget like the following:
Jan03 Feb03 Mar03
Widget sales 100 200 300
cost 50 100 150
I tried to use the crosstab query feature but it only allows me to specify
one value, so I can only include sales or cost. Does this mean I need to
develop 2 queries and pull them together in a 3rd query? If so, how do I do
that?
Any help is much appreciated.
John
I am a beginner and have set up the following simple table:
Date Product Sales Cost
Jan03 Widget 100 50
Feb03 Widget 200 100
Mar03 Widget 300 150
Date is my primary key. I want to be able to develop a query or report that
will show the months across the page in columns, and a separate sales and
cost row for each widget like the following:
Jan03 Feb03 Mar03
Widget sales 100 200 300
cost 50 100 150
I tried to use the crosstab query feature but it only allows me to specify
one value, so I can only include sales or cost. Does this mean I need to
develop 2 queries and pull them together in a 3rd query? If so, how do I do
that?
Any help is much appreciated.
John