Book

Suggestions


Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












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.



See all Topics

Labels: , ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment