school database with married couples

[Btdebbie]

I do a database for a school, we send mailings out twice a year to all graduates. When reunion time comes I have to run class list for some of the class. Married couples that both graduated from the same school, were once put in on a single line, for example John and Sally(Pike) Miller Rt. Everytown, IL 60000 and then their graduating years 1960 & 1972. With this example when you try to run a class report of just 1960 or 1972 they will not show up on the report. I also do mail merge to run the address labels. I have tried entering them in on separate lines, that solves the class list problems but then when you mail merge you have two letters going to one address. So you can find the duplicates and delete one but then you are leaving one of the graduates out. Any suggestions? Thank you.

[rpeare]

in the criteria of your your graduating years put

like *1960*

on your original data you'll get any record that has a graduate from 1960

which of course can be modified with something like:

like * & [Enter the Graduating Year] & *

or

like * & [forms]![formname]![graduatingyear] & *