Showing No Duplicates

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

Guest

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
 
Brad

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff
Sorry for the stupid question but i where can i find the properties for the
query??
thanks
brad
 
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
 
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
 
Back
Top