Formatting of report problem prob. Crosstab query

[DGK101]

Hi

I have got a bit of a problem that I need help to solve, I would much appreciate it if you could help.

My database is used for budgeting and I am going to illustrate my problem for you.

I have a table like this :

Month attribute 1 att2 att3 Att4 (etc..)
------------------------------------------------------------
Jan $10 $20 $30 $40
Feb $10 $20 $30 $40
Mar $10 $20 $30 $40
Apr $10 $20 $30 $40
May $10 $20 $30 $40
(etc..)


And I need a report that looks like this :


Jan Feb Mar Apr May (etc..)
-----------------------------------------------------------
Att 1 $10 $10 $10 $10 $10
Att 2 $20 $20 $20 $20 $20
Att 3 $30 $30 $30 $30 $30
------------------------------------------------------------
sub total
------------------------------------------------------------
Att 4 $40 $40 $40 $40 $40
Att 5 $50 $50 $50 $50 $50
------------------------------------------------------------
sub total
------------------------------------------------------------
(etc..)


I have seen a similar problem posted here , and a Crosstab query was suggested but I can't seem to get it to
work. Is there another way?

Thanks.

 

[67peshawar294]

DGK,
1. Create a query adding the three fields and any others you need for criteria, for the data. Define any criteria you need for date, price etc.
2. Create a crosstab query based on the above.
For the row heading select the att field.
Next, select the date field for the columns.
Next, select month for grouping.
Next, select sum.
Next, and finish.
3. Create your report based on the crosstab.
The grouping you have may prove difficult.
three and subtotal
two and subtotal
?
jim