12 month report

  • Thread starter Thread starter AMDGUY [MCP]
  • Start date Start date
A

AMDGUY [MCP]

Im trying to create a 12 month report. This report will be printed monthly
The user need to be able to select the ending month and year of the report.

The report needs to total opa opr and ops for each month from the data
table.
So the ending result would look like this

Month OPA OPR OPS
Jan 05 10 100 5
Dec 04 15 110 6
Nov 04 16 113 8
...... Until get 12 months from the user selcected ending date.
 
Although you don't mention the table strucure, it would seem that this
can be accomplished using a crosstab query.

Best regards

Maurice St-Cyr
 
Not sure what you mean by a cross tab query

Table structure is like this


DATA TABLE
Date opa opr ops
12/15/04 5 5 5
1/10/05 5 5 5
1/24/05 5 5 5

I want to get the totals for each month for 12 months on a report.
 
Back
Top