Limiting results

A

Anton

Hi all,

I am trying to create a query that sums up all used
operating systems used in my department.
But I want to have them shown just once.
i.e.
I dont want a list like:
WinXP
WinXP
WinXP
WinXP
WinXP
WinNT
WinNT
WinNT

but I want
WinXP
WinNT

Does anyone has a clue how to do this?
 
S

Steve Schapel

Anton,

Go to the query properties. If you are using the design view of the
query, you can right-click anywhere on the background of the upper panel
of the query design window, and then select Properties from the pop-up
menu. Then, set the Unique Values property to Yes.
 
Top