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.
One table, dupe address, diff owners (1 Viewer)
- Thread starter boethos
- Start date
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:
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:
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.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 these are three separate queries? If so, I tried them and am getting all the records. I'm missing something. Thank you for your time.
I did exactly that. I have 310 records.
Wooooowwwwww. Looks like what I'm looking for! Ya!
Thank you, thank you, thank you, thank you for your patience.
Similar threads
