multiple records

[toddbingham]

Have a query from 2 linked tables that have a relationship. I am pulling some records based on some criteria. It returns what I want, but sometimes the same person could have several records, I am getting all of their records. I need to exclude anyone that has a matching address. Does it make sense?
I have included a screen shot.

 

[SforSoftware]

Hi,

You can GroupBy address (look at View, Totals) or maybe it will do when you use SELECT DISTINCT instead of only SELECT in the SQL-statement (View, SQL)