Deb,

I'm sorry, but I don't understand your problem well enough to provide a possible answer. Can you provide an example of
a) the results of the query (multiple records for one person, I assume), in table or spreadsheet format (just a block of data)
b) the report definition that isn't working correcty (what's in the detail section; what's in the different headers and footers)
c) the erroneous results for this block of data with this report definition
d) the results wanted

It will be a LONG post, but that doesn't really matter. Putting an example database on a website, or providing it as an attachement to a private mail can be done later, if the normal way doesn't work.

Kees