I may be over simplifying this, so please bear with me....
I have a table which consists of monthly results per region per product. Each item within the table is its own individual record.
For example:
Record 1) 1/1/08, North, DSL, $100.
Record 2) 2/1/08, South, Longdistance, $250

I have created a query that I specifiy the periods I want to see, for example four months of South activity for all product types.

I would like to then create a report off this query, however I want to show each of the four periods $ amounts side by side each other in order to view the trend.

I cannot figure out how to create this so any assistance would be most appreciated.
Thanks

my guess is you need to look at "cross tab queries "

Thanks Uncle Gizmo!!
Most appreciated!!

One more question.....

I have created a query whereby I select the required parameters, and I have created the crosstab query off the initial query.

When creating a report off the crosstab query, it works fine initially, however when I change the parameters in the intial query, for example if I change the periods to be returned from Jan, Feb, Mar, Apr to Feb, Mar, Apr, May... the report will not pickup the May period or any other period that is different from the intial report.

So what I am saying is I want to be able to go into the query and change parameters, and for this to automatically be reflected in the report.

Am I missing something?

Many thanks