UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Limit To One Name, Access 2016    
 
   
wizcow
post Feb 17 2017, 11:50 AM
Post#1



Posts: 283
Joined: 10-April 03
From: B.C. Canada


Hello

I am using a query to bring up a list of employees who have expired tickets.
Some of the employees have more than one ticket that is expired, so their name shows up more than once in the query.

Is it possible to have the query only list their name one time?

Thank you
Tom

--------------------
Anything worth doin'
is worth OVER-doin' !!!
Go to the top of the page
 
jwhite
post Feb 17 2017, 11:56 AM
Post#2


UtterAccess VIP
Posts: 5,801
Joined: 31-August 06
From: North Carolina, USA


Add DISTINCT to your query and return just the name fields

--------------------
Go to the top of the page
 
BruceM
post Feb 17 2017, 01:23 PM
Post#3


UtterAccess VIP
Posts: 6,899
Joined: 24-May 10
From: Downeast Maine


Do you need to be able to edit the list? If so, a subuqery such as described here should do what you need. I'll leave it at that for now since I don't know if you need the ability to edit the records.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th October 2017 - 02:35 PM