change view of a report

[Guest]

I have a table with the month and year vertically but I need the month and
year to go horizontally. How do I do this so my end result can be printed on
a report? Would it be through a pivot table query? I need to show products
on the left and months on top so we can get a better idea of how products are
selling by month.

data now:
1/2007
2/2007
3/2007
i need:
1/2007 2/2007 3/2007

 

[Guest]

Use the query wizard to create a CrossTab query, it will walk you through on
how to specify the date as the header

 

[Guest]

OMG!!!! That was too easy. I used to use Access in the last company that I
worked for all the time and just totally forgot about doing that. Thanks!!!
You saved me ton of time.