title: Access Query where field populates if only matching another field
body: <p>I'm trying to figure out this query. I'm creating a make a table query and combining data from two tables, however I think it may be better to do a Crosstab query. Tables are Attendance and Intake. I want the field "username" and "attendance status" from Attendance table and "assignedto" and "actiondate" from the Intake table. I'm trying to be able to track which workers are available from the attendance tab and the number of cases assigned to them to populate from the "assignedto" only if the "actiondate" field is today's date and "assignedto" has names and should only populate if the name matches the "username" from the Attendance table as well. I hope that makes sense.</p>
  
  <p>Thank you.</p>