 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / March 2006Showing No Duplicates
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 > Simple question.. I think > [quoted text clipped - 11 lines] > > Thanks brad Jeff Sorry for the stupid question but i where can i find the properties for the query?? thanks brad > Brad > [quoted text clipped - 21 lines] > > > > Thanks brad Jeff Found it... But it did not work? Still showing 2 Toms? Brad > Brad > [quoted text clipped - 21 lines] > > > > 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 > Jeff > Found it... But it did not work? Still showing 2 Toms? [quoted text clipped - 25 lines] > > > > > > Thanks brad Post the SQl for the query Brad and i'll show you how to alter it. > Jeff > Found it... But it did not work? Still showing 2 Toms? [quoted text clipped - 25 lines] > > > > > > Thanks brad 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 > Jeff > Found it... But it did not work? Still showing 2 Toms? [quoted text clipped - 26 lines] >> > >> > Thanks brad |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.