Hi,
I've been searching the forum, but I'm not sure if I'm searching for the right terms.

Here is what I have.

I have a main table that stores my records, I also have another table for 'modified by' where users enter their name if they modified a record.

so each record could have many different 'modified by' users.

On my report, I'm trying to figure out how to format it.

Ideal would be to have it so
record #1
Data from main table etc

modified by XX 10/9/2007
modified by YY 9/8/2007


but what I'm gettin now is, it duplicates all the data for each modified entry.

So

Record #1
Data from main table etc (repeated each time)
Modified by XX 10/9/07

Data from main table etc (repeated each time)
Modified by YY 9/8/07

and so on for each time a person add thier name to the mofidied by field.

I'm guessing I need to do something either with the grouping in the report, or create another query?

not sure what to search for, to help me with this.

nevermind figured it out.

sub-reports!
Didn't think of that!!