Non-repeating values in drop down

[lc]

Hi,
I want to display the data from the database in a drop-
down list. However, some items are repeating and I was
wondering how can I display only unqiue values.
<%
strSQL3 = "SELECT tblEV3Location.Code FROM
tblEV3Location ORDER BY

tblEV3Location.Code;"
set cars3=adoCon.execute(strSQL3) %>
<select name="Code">
<% 'Loop through the recordset to make each entry
in the list. %>
<% do while not cars3.eof %>
<Option value = "<%= cars3(0) %>"> <%=
cars3(0) %></Option>
<%cars3.movenext
loop%>
</select>

Thanks.

 

[Kathleen Anderson [MVP - FP]]

Try:

strSQL3 = "SELECT DISTINCT tblEV3Location.Code FROM tblEV3Location ORDER BY
tblEV3Location.Code;"