Results 1 to 10 of 10
  1. #1
    giorgospsk is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9

    Exclamation Access 2010 Web database combobox, shows duplicated values

    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

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Post the full query so we can see it - or alternatively use a grouped query for your combo box instead of a select distinct. If you are just working with the dates, grouping should be fine.

  3. #3
    giorgospsk is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    well yes,
    I just want the values that show up in the combobox (dates) not to be duplicated. Nothing more.

    The combobox value is after being used as a parameter for another query and then, a report.
    I dont want the user who will pick a date from the combobox to see the same date, more than once.

    I will try the GROUP BY , but are you sure it works on web databases??? because SELECT DISTINCT finally does not...

  4. #4
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    It depends on the criteria of your query (which is why I suggested you post an example). If you use group by and your criteria is showing more than just the data that you want visible, you will need to determine what data elements in your query are causing the duplication and then remove the offending elements from the query...

  5. #5
    giorgospsk is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    i do not set any criteria in the query, actually. I just create a query, that containt the field "dates" and the results of this query is shawn in the combobox.
    The dates field (in the table) contains many duplicate values. This should not be changed.
    what i do is trying to set the select distinct, or group by, in the comboboxe's properties.
    Should I try to set the criteria on the previous level, which is the query properties???
    If yes, how could i do that????

  6. #6
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    If you are trying to group it by the individual dates, make sure that you are grouping on only the date portion of the date/time field and not the time portion as well. If you have time included it will contain all the dates for every timed event on that particular date.

    Create a query that selects only the date field or date portion of the field in the table, then group it on that field. It should give you distinct values at that point.

  7. #7
    giorgospsk is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    in access WEB databases there is no option of date and/or time ... it gives the option to choose just date. am i wrong.??
    also, whenever i try to just test if the distinct function is available in web databases, it says that it is not web compatible. this is why i asked you before if you have practically tested that it works in access web database.
    really thank you for helping me..

  8. #8
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Yes, I see what you are saying now. A quick search on this yields that it appears on the web it can only be done in a form... not what you need.

    Check this link for more info: http://www.utteraccess.com/forum/Tot...-t1950067.html

  9. #9
    giorgospsk is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    sorry, i didnt get you...could you explain me further?

  10. #10
    mmandel1 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    8
    DISTINCT and GROUP BY do not work on web databases in Access inside of SharePoint.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2010 Database Problem
    By RayMilhon in forum Access
    Replies: 5
    Last Post: 11-28-2011, 03:04 PM
  2. Replies: 4
    Last Post: 10-28-2011, 12:49 PM
  3. Access 2010 Database Documenter
    By Julie417 in forum Access
    Replies: 1
    Last Post: 08-12-2011, 06:24 PM
  4. Replies: 6
    Last Post: 05-05-2011, 08:50 AM
  5. Replies: 2
    Last Post: 07-24-2006, 09:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums