Report That doesn't generated duplicate Addresses HELP!!!

[Ninabunny]

I am trying to figure out how to generate a report that doesn't generate duplicate addresses.  This is started by a query but I cannot seem to figure the criteria for the address field.  PLEASE HELP!

 

[Guest_imported]

you need to be much more specific.

 

[Ninabunny]

OK here goes<br>This query is based on a table, the table will have many duplicate family last names and addresses etc.&nbsp;&nbsp;The query should weed out the duplicate last names and addresses so that when a report is generated only one newsletter goes to each household, not fifty.<br>Is that specific enough?

 

[Vandys]

If you mean that the lastname as well as the address is same for more than one record then there is a solution to it :-<br><br>Open the SQL of the query and add DISTINCT after the word &quot;Select&quot; and then run the query.<br><br>Check if this works...<br><br>Vandys