I'm setting up an Access 2007 database for my mother and need some help from someone in the know. The database tracks training and SOPs at the company she works for. Currently, I've got about 5 tables created, covering things like the SOPs, Document Revisions, Departments, etc. What I'm having problems with is creating the reports she needs from the tables. One of the tables contains all the SOPs and also has a multi-valued field with a dropdown box containing the departments in the company. The goal is to indicate which depts need the SOP training indicated by each record. So some records will have a single dept checked in that field, some will have 4-5 depts. I need to be able to create a report for each dept, showing the SOPs that each dept needs to be trained on. I tried writing a query: Select fields From table Where [Reqd for Dept(s)] = 'R&D' To pull the records where R&D is one of the selected values in that field. But Access is giving me the error "The multi-valued field [Reqd for Dept(s)] cannot be used in a WHERE or HAVING clause." So how do I select these records for a report?