I'm trying to filter a Crystal Report that has duplicate entries in a number of fields. The report is for mailing brochures to our company's customers. If we have separate customers at the same address they will each get a brochure but we want to limit this to one per address. The data looks something like this:

John Smith       123 Main Street      Jericho, KS    12345
Mary Smith       123 Main Street      Jericho, KS    12345
Mike Jones        136 Ascii Drive        Miami, FL      77777
Beth Jones        136 Ascii Drive        Miami, FL      77777    etc.

Since each record is different, the 'Select Distinct Records' in the Database menu has no effect. Also using 'Suppress if Duplicated' in the fields doesn't really help because the records are still out there. I need all of the data in each record for the mailings except in the case of multiple names.

Does anyone know a VB formula or SQL expression that I can insert into this report that will take out records with some fields identical and others different? For example IF Street + City + Zip is identical THEN display one record or something like that? I posted a similar question yesterday in the Report Design forum. Any help that anybody can offer is greatly appreciated. Thank you.