Unofficial Access Stuff

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

Host your Web site with PureHost!

Thursday, July 07, 2016 – 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 access
Labels: Customize, General, Queries, Reference, Tips, Tutorials

<Doug Klippert@ 3:53 AM

Comments: Post a Comment