If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Another MS Access Question

miju · 2004-08-02 14:15:13

Right quickie for ya'all I've done up a database in MS Access 2000 and basically want to publish the database to the internet to allow certain people I grant permission to. My problem is simple though (I think) When I'm using the web page creator and I put in a drop down box for counties when it appears on the web page it…

Options

02-08-2004 3:15pm

#1

miju

Banned (with Prison Access) Posts: 8,486 ✭✭✭

Join Date: December 2002

Posts: 7957

Right quickie for ya'all

I've done up a database in MS Access 2000 and basically want to publish the database to the internet to allow certain people I grant permission to.

My problem is simple though (I think) When I'm using the web page creator and I put in a drop down box for counties when it appears on the web page it lists every single occurance of each county.

So my question is simply how do I put in a drop down box with just one occurance of a county (hope to god ya'll know what i'm waffling about)

0

Comments

Options
#2 02-08-2004 3:31pm
PhilipMarlowe

Subscribers Posts: 4,419 ✭✭✭

Join Date: November 1999

Posts: 4178

http://www.w3schools.com/sql/sql_select.asp and read the bit about Select Distinct

0
Options
#3 02-08-2004 3:38pm
miju

Banned (with Prison Access) Posts: 8,486 ✭✭✭

Join Date: December 2002

Posts: 7957

thanks very much

0