Sort records by name

[Frank]

Hello All,

I have created a report that I am having trouble with. I
would like to have a separate page for each person's
records in a table. The page has their name (last, first,
mi) how many records are in the table, and some summary
calculations about those records. In the footer section I
have the following syntax:

="Summary for " & "'Last, First, MI' = " & " " & [Last,
First, MI] & " (" & Count(*) & " " & IIf(Count(*)
=1,"detail record","detail records") & ")"

This syntax is followed by some summary calculations for
all the records of a specific individual.

The problem that I am having is that the above syntax is
indicating an incorrect amount of detail records and the
report is not displaying all the individuals in the
database. Any help is greatly appreciated.

Thanks,
..

 

[Jim]

Try gouping on the person's name and move the syntax to
the group footer.