Tabular reports

[mysterybks]

I have a table with these fields:

title
month
year
sales


I want to take the data in that table and make a tabular report that will show each title along the left and then put the appropriate sales in a column by month like:

(headings)title 2011-June 2011-May 2011-Apr

Title 1 3 5 0
Title 2 4 6 11

How do I do this? I know I've done it in the past but it's been so long, I can't remember how.

Thank you!

 

[JamesMcS]

That'll be a crosstab query - use title as the row heading, month as the column heading and a sum (or whatever) of sales as the value.