Query Multiple Names in a Table

[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

 

[Rick Brandt]

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

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.