Results 1 to 2 of 2
  1. #1
    paddyflan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2010

    Is it possible to do a query on a multi-value field

    Basically, I have a small spreadsheet that represents employees and their access for certain things on different campuses. I have attached the document......I have been asked to create a report of all those people who have a Component name of "campus" where "Component IDs from" equals 40 or 80. The problem I am having is when a record matches the criteria, I also need to list the subsequent related records. So for instance, in the query, the first record in the spreasheet matches the criteria but for the report I also need to list the other records for that employee which in this case is CC.

    any pointers would be very much appreciated.

  2. #2
    Dinzdale40 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    If i am understanding you correctly you just have one table. So just include all the fields that you want to see keeping your criteria the same.

    Then use the report wizard with the query you created above as the record source and use the employee as a grouping level so that it will list the employee and then all the fields you want to see based on your query's criteria.

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

Similar Threads

  1. Replies: 7
    Last Post: 11-24-2014, 02:11 PM
  2. Append Query - Multi-Valued Field
    By catat in forum Queries
    Replies: 0
    Last Post: 05-11-2010, 01:52 PM
  3. How to Query a Multi Value Combo Box
    By Viperpurple in forum Queries
    Replies: 0
    Last Post: 03-22-2010, 07:33 AM
  4. Multi value field - Combobox help
    By stougch in forum Forms
    Replies: 0
    Last Post: 10-19-2009, 10:47 PM
  5. Replies: 1
    Last Post: 06-01-2009, 01:09 PM

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 - Senior Forums