Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, October 31, 2009 – Permalink –

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.



[Edited entry from 10/17/2006]




See all Topics

Labels:


<Doug Klippert@ 3:10 AM

Comments: Post a Comment

Links to this post:

Create a Link