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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Months disorder 3
Looking formula that gives total of remaining months 6
Rolling 12 Months Data 9
Grouping monthly data 4
2 dimensional date sort 1
Summing Groups in Reports 2
Rolling 12 Month Report 4
Change a report to a query 1

Back
Top