REPORT BY NAME AND MONTH

[Beerman3436]

I need to know how to produce a report by name and month.

What I have is records that are assigned a date i.e.(03/29/00), and one or more names are assigned to this record for that date.

I need to produce a report that will list each name, and each month, and the total record each person has for that month.

EXAMPLE:

NAME JAN FEB MARCH APRIL MAY JUNE etc..
John Doe 2 3 25 10 3 3
Jane Doe 10 6 12 8 2 1

 

[Pat Hartman]

Create a crosstab query and use that as the recordsource for the report.

 

[Beerman3436]

I have that now. Now do you know how I can put a new column on the report that will put a 1 thru 10 for the Top 10 people.

If I have 200 people on the report then I only want the numbers to display on the top 10 people. Not all 200 of them.