sorting out duplicates

[kato68]

I want to create a query that retrieves all records (name and address fields) that fall between a given date range. Some of the records will show up more than once. I want the query to only return the record one time. The problem is that the users who entered the addresses didnt enter them exactly the same every time. I dont care which value the query returns, just that it returns it only once. (Im using the query to create mailing labels)

Any idea how I can retrieve only one record?

btw, the name fields will be entered correctly every time.
The ones that are varied are the address fields.

And it would be pointless to clean the table up, because the users will probably just enter the fields differently in the future which would mess things up later.

 

[Pat Hartman]

Create a totals query that groups by the name fields and uses first or last to select the address fields.