Hiding Duplicates in Query Results

Once is enough

It's easy to hide duplicate entries when you run a query, even though Access doesn't go out of its way to call attention to this ability.

• Set up a query as usual using the design grid.
  
  
• Choose View>Properties from the menu bar to display the Query Properties dialog box.
  
  
• Change the Unique Values property to Yes.

Access displays unique records based on each field returned by the query.



See all Topics