combining records with certain criteria

[KRuss182]

I want to be able to combine records with certain criteria. I have a table that lists individuals; each individual has a first name, last name, address, city, state, zip, etc. If Jack Smith lives at 123 Someplace Street in Somecity, Somestate, and Jill Smith lives at 123 Someplace Street in Somecity, Somestate, I want to create a report that outputs:

Jack & Jill Smith
123 Someplace Street
Somecity, Somestate

If there are multiple names for the same address, I would like it to seperate them by commas and place and before the last name.

Would it be best to write a module or do this via query. I am using MS Access 2000.

Thanks.

[KnooKie]

Use a query.......

Have a look at the 'Group By' part of a query. Essentially it allows you to GROUP together items with the same criteria. The help file should have some examples.