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?

I think your only option with Access is to call it four times, once for each field...

What do you mean "call it four times"?

<%
    sSQL = "SELECT DISTINCT Fund" & _
           " FROM MASTER_TABLE_cfoapal2"
    set rs = Connect.Execute(sSQL)

    sSQL = "SELECT DISTINCT Org" & _
           " FROM MASTER_TABLE_cfoapal2"
    set rs = Connect.Execute(sSQL)
%>

Will something like this work?

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]

Have you tried:

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