Help with Report Set-up

[ecupirate]

I'm kinda new at setting-up reports...
The fields I am using are EmployeeID,Employee, IndPoints, TeamPoints and Month, Year,PotentialPercent,and ActualPercent.
Each month is a diferent entry in the table/Query consisting of IndPoints,TeamPoints, etc. I want my report to look like the below..
April May
Employee: IndP TeamP.. IndP TeamP ..
John Smith 10 30 50 10
Paul Jeffers 20 40 30 20

If I group a query by Month I get everything listed in columns.

Any suggestions on how I can get the above results. Do I need a query for each month? Do I need to use DLookup to pull every value from a query?

Thanks,

 

[RichMorrison]

Look in Help for "Crosstab". There are wizards for creating crosstab queries and reports.

RichM