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.