Query criteria - list same information only once


A

Anita

I have a query that shows multiple records with the same information. How do
I sort this query to only show different records. Example: One company is
listed three times. I want my query to list this company only once.
 
Ad

Advertisements

J

Jeff Boyce

Anita

Open the query in design mode.

Find the query Properties (one way: right click in the open space above the
grid, selecte Properties).

Find the Unique Values property and set it to Yes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Ad

Advertisements

S

Steve Schapel

Anita,

In design view of the query, right-click anywhere on the background of
the upper panel of the query design window. Select 'Properties' from
the popup menu. Set the Unique Values property to Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top