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