Month by Month comparisson, Current year Vs. Lat Year.

[wameri]

Cystal 9, Access 2000.
I am trying to run a comparisson of current year vs. last year, month by month.
Please help on how I can achieve the following,

What I have on the crosstab

12/2005 11/2005 10/2005....12/2004 11/2004 10/2004
Units 5000 4800 6000 6000 4500 4600

What I would like

12/2005 12/2004 11/2005 11/2004 10/2005 10/2004
units 5000 6000 4800 4500 6000 4600

Thanks in advance.

 

[lbass]

Make month your first column field, and year your second. Then suppress the year labels and subtotals.

-LB