Office Tips and Hints Blog

Saturday, October 31, 2009 – Permalink –

Hiding Duplicates in Query Results

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.

[Edited entry from 10/17/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:10 AM

Comments: Post a Comment

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>