Suggestions welcome

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I am at a bit of a crossroads, I dont even know wher I
should go. So I will tell yo ume problem and see if
anyoe has any good ideas.

I have a table with the following fields:

LOB
Program
Project
Month
Actual
Budget
Direct
Indirect

I would like to run a query that can sum the actuals in
for each Program for each month. An example would look
like:

01/03 02/03 03/03 04/03 05/03

Program1 6 7 13 12 10
Program2 10 21 4 6 8

----------------------------------------------------------

Ideally I would like to have one query statement do this
for me but I am pretty sure that cant be done since I
only have one month field. So I was wondering if someone
could give me a few suggestions on how to go about this.
Would I need to create another table just for the months,
if so should I have a permanent one or just one that is
created and deleted every time the query is run. Any help
would be greatly appreciated.

Thanks,
Chad
 
I would like to run a query that can sum the actuals in
for each Program for each month. An example would look
like:

01/03 02/03 03/03 04/03 05/03

Program1 6 7 13 12 10
Program2 10 21 4 6 8
Click to expand...

It's called a Crosstab query and it's pretty easy. Just use the
Crosstab Query Wizard on the New Queries tab.
 
Back
Top