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!
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!