help!!! preventing duplicates when populating a dropdown box.

[tuam1234]

when i add in "Distinct" to

check= "SELECT Leaving, Destination, arrTime, depTime FROM Holidays"

it groups all the same occurences together.

ie. before i added it in i got:
london
edinbouragh
london
london
edinbouragh

when distinct is added i get:
london
london
london
edinbouragh
edinbouragh

any suggestions??

 

[PHV]

If you want only one column from your table then Select only one, like this:
SELECT DISTINCT Leaving FROM Holidays
otherwise you may consider to take a look at the GROUP BY clause and the Agregate functions.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884