469,352 Members | 2,150 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,352 developers. It's quick & easy.

Drop List Question

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
Jul 22 '05 #1
5 1039
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

Jul 22 '05 #2
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

Jul 22 '05 #3
> I have a table with the following information:

tom
dick
harry
tom
tom
dick


Why does your table allow duplicates?
Jul 22 '05 #4
Ray Costanzo [MVP] wrote:
Try
SELECT DISTINCT [column_name] FROM yourTable


Thanks
Jul 22 '05 #5
"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
Jul 22 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jonnytansey2 | last post: by
2 posts views Thread by ramesh | last post: by
reply views Thread by Benny | last post: by
13 posts views Thread by Leszek Taratuta | last post: by
2 posts views Thread by Yoshitha | last post: by
4 posts views Thread by Chris Kettenbach | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.