Ok I need a little help, I am trying to count the numbers of records in a table that match the number of records from another table and counting how many of those each ID has.
I thought this would work but no go....
Can anybody help me?
Code:
StrSQL = "SELECT COUNT(ID) FROM tblCurrentTraining INNER JOIN tblJobFunctionsReqs ON tblCurrentTraining.TrnNo = tblJobFunctionsReqs.ReqNo GROUP BY tblJobFunctionsReqs.JobFunction, tblCurrentTraining.ID HAVING (((tblJobFunctionsReqs.JobFunction)='AOI Operator'));"
I want to use a SQL style statement if at possible