I did try that, but could only get it to find dupe of one column, not checking two columns. I don't need the dupes of owner and property, I need same property, different owners.
So, this is just the method we discussed back in my first post. You will need 2 subqueries to get the data you want, here's the SQL for the first:
Code:
SELECT Sample_HSU_DB.Both_Name, Sample_HSU_DB.Both_addr
FROM Sample_HSU_DB
GROUP BY Sample_HSU_DB.Both_Name, Sample_HSU_DB.Both_addr;
Paste that into a new query object and name it '_sub1'. It gets all the unique name/addr permuations in your data. Next use this SQL:
Code:
SELECT [_sub1].Both_addr
FROM _sub1
GROUP BY [_sub1].Both_addr
HAVING (((Count([_sub1].Both_Name))>1));
Paste that into a new query with the name '_sub2'. It determines all the addr values that have multiple distinct name values. Finally, to get your data use this SQL:
Code:
SELECT Sample_HSU_DB.*
FROM _sub2 INNER JOIN Sample_HSU_DB ON [_sub2].Both_addr = Sample_HSU_DB.Both_addr;
So, this is just the method we discussed back in my first post. You will need 2 subqueries to get the data you want, here's the SQL for the first:
Code:
SELECT Sample_HSU_DB.Both_Name, Sample_HSU_DB.Both_addr
FROM Sample_HSU_DB
GROUP BY Sample_HSU_DB.Both_Name, Sample_HSU_DB.Both_addr;
Paste that into a new query object and name it '_sub1'. It gets all the unique name/addr permuations in your data. Next use this SQL:
Code:
SELECT [_sub1].Both_addr
FROM _sub1
GROUP BY [_sub1].Both_addr
HAVING (((Count([_sub1].Both_Name))>1));
Paste that into a new query with the name '_sub2'. It determines all the addr values that have multiple distinct name values. Finally, to get your data use this SQL:
Code:
SELECT Sample_HSU_DB.*
FROM _sub2 INNER JOIN Sample_HSU_DB ON [_sub2].Both_addr = Sample_HSU_DB.Both_addr;