Query Multiple Names in a Table

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / December 2005

Query Multiple Names in a Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jamie Harbour - 02 Dec 2005 13:27 GMT

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

Reply to this Message

Rick Brandt - 02 Dec 2005 13:40 GMT

> Hello
>
[quoted text clipped - 5 lines]
>
> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

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.