Hiding duplicates in a query

R

Ron DeGregorio

Is there a way to hide duplicates in a query? I would like to use a make
table query to make a lookup table but I need to see only 1 of each
repeating for the lookup table.
 
P

PC Datasheet

Create your query then right click in the query window where your table is
at. Click on Properties in the dialog that appears. Set the Unique Values
property to Yes.
 
Top