Help! Repeat Grouping Max?

[bluke]

I've been asked to create a report that looks like below:
Region
8/3/2009
8/2/2009
8/1/2009
etc…
Department
8/3/2009
8/2/2009
8/1/2009
etc…
SalesPerson
8/3/2009
8/2/2009
8/1/2009
etc…

The Date is one field in the base query but used multiple times (repeated) in the grouping. If I repeat it once ( 2 total) the outcome is fine. But it I try 2 or more repeats the the grouping isn't successful and the data doesn;t group accurately. Is there a reason for this and is 2 the maximum number of times you can repeat the same grouping field? Your help is sincerly appreciated.

bluke

 

[Mattster]

I am assuming that you are using two tables one that contains the different sections
Region, Department and Salesperson ...

And a second table that contains the dates.

if you link these together with no joins I believe that you will have the dataset that you are looking for. Then just sort and filter how you would like.

 

[boblarson]

subreports could also work.