Alright, I have a db with three tables - tbl-emp which lists employees, tbl-pay which lists pay periods (id and rough dates) and tbl-details which records roster/availability/actual shifts worked etc (these are stored as check boxes i.e. Monday Week 1 of Pay period 1 AM has its own box, PM and NT have their own box.
Now, I need to work out which employees have available for certain shifts i.e. AM on Tuesday week 2, and alos generate a list of employees who have worked less that 'x' shifts.
I have been using the =sum formula in previous queries - making a query, then using the =sum in the report page footer to calculate the totals.
However, i cannot get these to work. Any help would be greatly appreciated.
Cheers
Now, I need to work out which employees have available for certain shifts i.e. AM on Tuesday week 2, and alos generate a list of employees who have worked less that 'x' shifts.
I have been using the =sum formula in previous queries - making a query, then using the =sum in the report page footer to calculate the totals.
However, i cannot get these to work. Any help would be greatly appreciated.
Cheers