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?