Additional Criteria

T

TimT

This sounds simple but I'm coming up blank.

table one: tblStaff
StaffID
Name
Dept

table two: tblTimesheets
StaffID
Date
Hours

qryStaffTime
Timesheets!StaffID
Staff!Dept
Timesheets!Date
Timesheets!Hours

qryStaff!Dept criteria is "ADMIN" and that works fine but where I'm running
into a problem is I have two other tables that I want to add as criteria for
the StaffID.
tblAdditions and tblExclusions
I want to include all records from qryStaffTime and add records where
tblStaff!StaffID = tblAdditions!StaffID and exclude records where
tblStaff!StaffID = tblExclusions!StaffID

Please Help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top