Counting All Records by Employee

  • Thread starter Thread starter Help4me
  • Start date Start date
H

Help4me

I have a database with two tables: Assignment and SubAssignment (foreign key
from Assignment table). I made a late assignment report sorted by staff
which includes all their late assignments from both tables. I have a count
field that counts their total number of late assignments. On the same
report, I would like to have a field that counts their total number of
assignments (both late and not late) so I can show a percentage of late cases.

What function (or whatever) can I utilize to perform this calculation,
adding records from both tables, whether late or not? I tried both DCount
and DLookup...
 
I have done something similar.
You could have another query that counts the assignments by user. Have
another that counts the late ones. Yet another that links the two togther
and calculates the percentage.

Use that as you main report and your current report as a sub report.

hth

Vanya
 
Back
Top