How to show unique records from a specific column in Access 2007 query?
Posted on 2011-10-17
I'm trying to create a query in Microsoft Access which has about 4 columns. I'm trying to show only those records that are unique for a specific column, but I'm having trouble doing so.
My query has a column with unique ID Numbers along with unique codes. The ID numbers do not duplicate, but the codes do- so I'm basically trying to generate a query that shows me all the possible unique codes. Can anyone help me?