Hi Les,
There are 8641 records in "tblacuteservices" that do not have a code number if I click in any of those blank fields and filter by selection I will only get 1 record. For some reason the table thinks that every record has a value in the code field. Here are the SQL'S:
Query 1
SELECT tblacuteservices.Directorate, tblacuteservices.StaffGroup, tblacuteservices.PayNumber, tblacuteservices.Code, tblacuteservices.Left
FROM tblacuteservices
WHERE (((tblacuteservices.Code)<>"") AND ((tblacuteservices.Left)=""));
Directorate StaffGroup PayNumber Code Left
Medical Nursing (Tr.) G0807397 N1000
Medical Nursing (Untr.) G5931169 N1001
Medical Nursing (Untr.) G5808448 N1001
Query 2
SELECT tblacuteservices.Directorate AS Division, tblacuteservices.StaffGroup AS [Staff Category], Count(tblacuteservices.PayNumber) AS TotalStaff, tblacuteservices.Left
FROM tblacuteservices
GROUP BY tblacuteservices.Directorate, tblacuteservices.StaffGroup, tblacuteservices.Left
HAVING (((tblacuteservices.Left)=""));
Division Staff Category TotalStaff Left
ACCIDENT & EMERGENCY Nurse - Qualified 84
ACCIDENT & EMERGENCY Nurse - Unqualified 15
ANAESTHETICS Administrative & Clerical 17
ANAESTHETICS Ancillary Staff Council 7