Filtering for Unique Records in a specific field

[Guest]

Does anyone know how to filter a field in access so that it shows you only
unique data....i have a large database w/ multiple fields containing
repeating data.

 

[Smartin]

Does anyone know how to filter a field in access so that it shows you only
unique data....i have a large database w/ multiple fields containing
repeating data.

Not sure if this is what you are looking for: this will show only those
rows where the value in UNIQUECOLUMN appears exactly once in that column.

SELECT *
FROM MYTABLE AS T1
WHERE T1.UNIQUECOLUMN IN (
SELECT T2.UNIQUECOLUMN
FROM MYATBLE AS T2
GROUP BY T2.UNIQUECOLUMN
HAVING COUNT(T2.UNIQUECOLUMN) = 1);