Background: I have a report that was manually created in Excel 97 that I'm trying to duplicate in Access.

Layout of the Excel report:

Location PPE 1/6/02 PPE 1/13/02
Disc. #Pays % Disc. #Pays %
Site 1 2 220 .91% 1 239 .19%
Site 2 19 798 2.38% 32 763 4.19%
Site 3 0 215 0.00% 6 188 3.19%
. . . . . . .
. . . .
...and so on....

The information from the Excel reports have been inputted into two seperate data tables(one for Discrepancies, one for # Pays). The percentages are calculated in a query.

I have another query that displays all the data I need for the report:

Location WeekEndingDate Discrepancies #Pays %
Site 1 1/6/02 2 220 .91%
Site 1 1/13/02 1 239 .42%
Site 2 1/6/02 19 798 2.38%
Site 2 1/13/02 32 763 4.19%
Site 3 1/6/02 0 215 0.00%
. . . . .
...and so on....


I'm having trouble setting up my report to follow the same format as the Excel report. I'm not sure how to set up"vertical groups". I'm not even sure if that's the right term to use.

My report basically looks like this:

Location
PPE 1/6/02
Disc. #Pays %
Site 1 2 220 .91%
Site 2 19 798 2.38%
Site 3 0 215 0.00%
. . . .
. . . .


PPE 1/13/02
Disc. #Pays %
Site 1 1 239 .19%
Site 2 32 763 4.19%
Site 3 6 188 3.19%
. . . .
. . . .


Is there anyway to put the PPE groups of data together so they display across the page like they do in the Excel report rather than vertically in my report? I'm familiar with coding so if coding is required, then I'm all ears.

Many thanks in advance.