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).