Query Multiple Names in a Table

  • Thread starter Jamie Harbour via AccessMonster.com
  • Start date
J

Jamie Harbour via AccessMonster.com

Hello

I have a table of staff who can perfrom a particular role, however some
people can perform many roles. I would like a query that only shows the
persons name once. Is this possible,

Thanks

Jamie
 
R

Rick Brandt

Jamie said:
Hello

I have a table of staff who can perfrom a particular role, however
some people can perform many roles. I would like a query that only
shows the persons name once. Is this possible,

Thanks

Jamie
Click to expand...

SELECT DISTINCT [FieldName]
FROM TableName

In the query graphical designer the DISTINCT is accomplished by opening the
property sheet and setting "Unique Values" to Yes.
 
Top