title: Very basic question re Many to Many queries MS-Access
body: <p>Apologies in advance for the banal and basic nature of this question, but I'm brand new to Access. I've searched my Access books and bibles, online, etc and cannot solve this very simple problem:</p>
  
  <p>I have a many to many relationship set up for Employees and Events they may attend. An employee can attend many events. An event can be attended by many employees. I have no trouble writing a query to list Employees who have been on - say - Event A <b>OR</B> Event C. What I can't do is write a query to list employees who have been on (for example) Event A <b>AND</b> Event C.</p>
  
  <p>I have three tables:
  <br><b>Employee</b>. Key: EmployeeId. (<i>Also contains name, position, etc</i>)
  <br><b>EmployeeEvent</b>. Keys: ID, EmployeeID
  <br><b>Event</b>. Key:EventID (<i>Also contains event name, date etc</i>)
  <br>Employee links to EmployeeEvent on Employee.EmployeeID=EmployeeEvent.EmployeeID
  <br>Event links to EmployeeEvent on Event.EventID=EmployeeEvent.ID
  <br> No problem with OR queries. Simply don't know how to make AND queries work.
  <br>This is my first ever post, many thanks in advance for your help!</p>