Month wise two years data comparison

[waqas]

dear all,



i have two years data in one table i want to show month wise comparison in one report,

what should i do?

column should be like as below.

2011 2012

month, year, normal hrs, OT hrs, total hrs ---------------------month, year, normal hrs, OT hrs, total hrs,

[Stingaway]

Write your query to pull all of the data and then use grouping in your report to do the rest...

Or throw it into Excel and do a pivot table off of it for an interactive approach.

[jzwp11]

If you want to show the two annual datasets side-by-side in the report, then I would suggest creating a query for each year

qry2011Data and qry2012Data

Then create a third query that uses the 2 annual data queries and join by the month field in each. Include all the fields you want from both annual data (you will have to rename on set of fields with aliases. Base the report on this third query.

By the way, the words "month" and "year" are reserved words in Access, so they should not be used as field names or table names.