I put this in another section...but I think it really should go here.

I have a access db with 4 different fields I need to get distinct info from. Each field has hundreds of duplicates...I want to get the distinct values for each column or field and put them in dropdown menus.

This is easy to do for one field or column.

<%
    sSQL = "SELECT DISTINCT Fund" & _
           " FROM MASTER_TABLE_cfoapal2" &_
           " ORDER BY Fund"
    set rs = Connect.Execute(sSQL)
%>
<snip>------------
<select name="dropdown1">
<% Do until rs.eof %>
 <option><%=rs("Fund")%></option>
<% rs.MoveNext
   Loop %>
</select>

I don't know how to do it for multiple fields...
I can't use SQL = "SELECT DISTINCT Fund" DISTINCT Org, because it gives me an error message. I also can't use sSQL = "SELECT Fund, Org", because I get hundreds of multiple entries for each of the two dropdowns.

How do I do this?
Do you need more information?

Have you found a solution to this? I have something similar.

sqlDrop1="SELECT ID,Manufacturer,Model FROM products"
sqlDrop1=sqlDrop1 & " WHERE Manufacturer LIKE '" & TOC & "'"
sqlDrop1=sqlDrop1 & " ORDER BY Model"

I want the ability to select the distinct of the model and only list one of each of the models in the above query. Currently, the above will show all the models (including duplicates).

[email protected]