I am using the following query to get duplicates in a table:
SELECT FirstName, LastName, Num, COUNT() AS NumberDuplicates
GROUP BY FirstName, LastName, Num
HAVING (COUNT() > 1)
ORDER BY NumberDuplicates DESC
I want to add to this query where it will only return duplicates where a field calle RefNum contains data.
Anyone know how I could achieve this?