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.
 
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
 
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.
 
Joined
Apr 6, 2022
Messages
1
Reaction score
0
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.
Thanks. Was not taught that in school. For some reason the professor wishes to ask questions that are well outside the box like if you're a Chicago Cubs fan somewhere on Sheffield Street
 

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