Need Help With Report

[Parra]

I have a query that gives me the following data "example":

Customer Year Revenue
Cust 1 2001 500.00
Cust 1 2002 600.00
Cust 2 2001 870.00
Cust 2 2002 400.00
Cust 3 2002 300.00

I need to create a report that will present the data like this:
2002 2001
Cust 1 600.00 500.00
Cust 2 400.00 870.00
Cust 3 300.00 0.00

Of course this is just an example, this will be used to compare the revenue generated by our customers Year over Year. I am having a lot of trouble with this. Please help this is driving me crazy ......

 

[Joe4]

You can create a query that produces those results, then do a report from that query.

Go to Query and create Cross-Tab query using the Wizard. Select the table you want to run it off of (your first table in your post), then choose Customer as your Row, Year as your Column, then Amount in your body (use the mathematical function "First" to get just the value).

You should then have a query that looks like your second table in your post (you may have to delete a "Total" column that Access may automatically add in there). Then create your report based off this query.

 

[Parra]

OK that works fine but I have 2 values, that need to be summed. What do you recommend?