Hello
. I am working on an Access 2010 WEB-enabled database.
I have a table that stores dates, names (of the students) and courses (that the particular student missed, because of apscence) i created a query, so i can recall specific dates' apscence. i choose the available dates form a combobox, but the only thing i dont want is the duplicate values in that combobox. for example if, on 12/23 there where 3 students not present, the combobox will show three times 12/23.
To avoid duplicates i have to use the SELECT DISTINCTand this is what i do. It actually works locally, but when i publish the database on my sharepoint site, it returns the following:
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.
can you please advice me?? thank you