Calcualting monthly totals from individual records

[JimmyG]

I have created a report to display total sales values for each month, the original orders are entered using the actual date, e.g. 03/08/2004. The report runs off a query which lists each individual sale, I have then attempted to group each sale into a monthly sales total. I have been able to convert the dates into the format I require for my report i.e. mmmm yyyy but I cant total the results with the same month and year together as one record. Please note I do not want to group all the results for each month together I want to calculate a total and display only this figure. Can anyone help?

e.g. This is what I have

Customer Name: Stationary World

Product Order Date Value
Blue Pens January 2004 £300
Blue Pens January 2004 £500
Blue Pens January 2004 £150
Red Pens February 2004 £100
Red Pens February 2004 £300


What I really want is:

Product Order Date Value
Blue Pens January 2004 £950
Red Pens February 2004 £400

 

[Rich]

Use a totals query and base the report on the query

 

[JimmyG]

The Report is already based on a totals query, each order is actually made up of seperate items within a category so the query totals these seperate items and displays the total for each order date.

What I need to do is then use these totals to create monthly totals. This would be required if a customer places two orders in the same month for products in the same category.

 

[AN60]

Is this too simple? Hide the Detail section of the report (Visible set to No) and you will then only see the Totals in the Report footer(s).