Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Unanswered: Multi Valued field cannot be used in a group by clause

    Hi, can someone please help me? I have an access 2010 database query. I have check box fields to tick to use for my controlled document linked references. I have added these fields and their .value fields to my query. I have added criteria to each of the vale fields (7 fields in all) so that when I run the query I can add in the document reference that I'm looking for and the query will return all records that have that document checked as relevant. The query runs but brings back multiple lines of the same document. When I try to use the group button I get an error message saying multi valued field cannot be used in a group clause. How can I do this? Many thanks.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 32
    you cannot query on Multi Valued fields.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •