Excluding data from queries

[BeltaneTheShaman]

I have a table which contains a set of constant values repeated in
pairs- one value for one staff member, and exactly the same value for
that staff member's partner. I need to formulate a query that will
strip the table of all duplicate values; I don't care which value in a
pair of identical values, is removed, but the query should always
produce a set of unqiue values.

Any Suggestions?

 

[Frank]

In the query design view. if you right click on the grey
area of the upper window and chose properties you have
the option of chosing unique values. Is this what you
mean?
Regards,
Frank