Limiting results

  • Thread starter Thread starter Anton
  • Start date Start date
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?
 
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.
 
Back
Top