Hello, I have been using an sql statement to populate ''distinct'' values for a combobox row source:
Code:
SELECT DISTINCT Contacts.[Batch] FROM Contacts WHERE Contacts.[Batch] IS NOT NULL
ORDER BY Contacts.[Batch];
I am using access 2010 and this simple sql statement tested perfectly but is not compatible with web databases. After trying to publish my db i get an error "ACCWeb103902" explaining "Access was unable to convert the query for use on the Web because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web".
Is there another way that I can use to remove duplicate values from my row source??