/* Statement 1:
    Find completed rechecks from current year (or last 12 months) and tally them up by staff member
        Object is to understand current workload */
SELECT dbo_a2contact.t_contfollowupstaff,
       Count(dbo_a2contact.parcelno) AS CountOfParcelNo
FROM (dbo_a2contact
      INNER JOIN dbo_asassesroll ON dbo_a2contact.parcelno = dbo_asassesroll.parcelno)
INNER JOIN dbo_asco ON (dbo_asassesroll.year = dbo_asco.curryear)
AND (dbo_asassesroll.cono = dbo_asco.cono )/* Options here would be great, maybe last 12 months, or multiple pages like the sales one*/
WHERE ( ((dbo_a2contact.done) = -1)
  AND ((dbo_asassesroll.usecode) = "r")
  AND ( (dbo_a2contact.contdate) >=# 1/1/2018 # ) )
 GROUP  BY dbo_a2contact.t_contfollowupstaff
  ORDER  BY dbo_a2contact.t_contfollowupstaff;