Query criteria - list same information only once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Back
Top