[AccessD] How to create a 2 year multimonth report

I have to create a summary report which has to include this year's data and
last year's data.  It is to look something like this:

Item      Jan 04   Jan 03   Feb 04  Feb 03  Mar 04  Mar 03

Meals      200      198        210   209      185       190

Rooms    30         28           34       34         29         31

 

I can do the summary for 04 and 03 but I can't figure out how to get the
months together like above.

 

Susan Klos

Senior Database Analyst

Evaluation and Reporting

Florida Department of Education

850-245-0708 

sc 205-0708