Drop List Question

[C White]

Hi Everyone

I'm having some problems finding the help I'm looking for so perhaps
someone here can point me in the right direction.

I have a table with the following information:

tom
dick
harry
tom
tom
dick

i would like the drop list to generate the following:

tom
dick
harry

can anyone provide with links/sites to read how to to this, I'm having a
hard time finding this when searching

(for those who are so interested the information is stored in an access
2000 database)

thanks

[Ray Costanzo [MVP]]

Try
SELECT DISTINCT [column_name] FROM yourTable

--

Ray at work
Microsoft ASP/ASP.NET MVP
"C White" <cw****@theatomicmoose.ca> wrote in message
news:HY********************@rogers.com...

Hi Everyone

I'm having some problems finding the help I'm looking for so perhaps
someone here can point me in the right direction.

I have a table with the following information:

tom
dick
harry
tom
tom
dick

i would like the drop list to generate the following:

tom
dick
harry

can anyone provide with links/sites to read how to to this, I'm having a
hard time finding this when searching

(for those who are so interested the information is stored in an access
2000 database)

thanks

[Curt_C [MVP]]

Select Distinct

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"C White" <cw****@theatomicmoose.ca> wrote in message
news:HY********************@rogers.com...

Hi Everyone

I'm having some problems finding the help I'm looking for so perhaps
someone here can point me in the right direction.

I have a table with the following information:

tom
dick
harry
tom
tom
dick

i would like the drop list to generate the following:

tom
dick
harry

can anyone provide with links/sites to read how to to this, I'm having a
hard time finding this when searching

(for those who are so interested the information is stored in an access
2000 database)

thanks

[Aaron [SQL Server MVP]]

> I have a table with the following information:

tom
dick
harry
tom
tom
dick

Why does your table allow duplicates?

[C White]

Ray Costanzo [MVP] wrote:

Try
SELECT DISTINCT [column_name] FROM yourTable

Thanks

[Roland Hall]

"Aaron [SQL Server MVP]" wrote in message
news:eC**************@TK2MSFTNGP14.phx.gbl...
:> I have a table with the following information:
: >
: > tom
: > dick
: > harry
: > tom
: > tom
: > dick
:
: Why does your table allow duplicates?

I agree. If you don't control the duplication, every Tom, Dick and Harry is
going to be in your database.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp