Showing No Duplicates

B

Brad

Simple question.. I think

My query is showing the same name 2 times I want to only see the name one time
Example

Staff members Vacation Pay
John
Bill
Tom
Bill

What do I enter in the criteria to show only one bill or tom ect.

Thanks brad
 
J

Jeff Boyce

Brad

Open the query in design mode. Select Query | Properties. Change the
Unique Values property to Yes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

Brad

Jeff
Sorry for the stupid question but i where can i find the properties for the
query??
thanks
brad
 
G

Gav

Post the SQL for the query Brad and i'll show you how to amend it. You need
to add the DISTINCT clause in.

Gav
 
M

Michel Walsh

Hi,

You probably selected more than one field. Select just one field, or, if you
need some of the other N fields, use:


SELECT Employee, LAST(otherField1), LAST(otherField2), .... ,
LAST(otherFieldN)
FROM myTable
GROUP BY Employee




Hoping it may help,
Vanderghast, Access MVP
 
Top