Hiding duplicates in a query

  • Thread starter Thread starter Ron DeGregorio
  • Start date Start date
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.
 
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.
 
Back
Top