Parameter Query or Code for Mail Merge Report

  • Thread starter Thread starter MariaL
  • Start date Start date
M

MariaL

I'm not really sure how to approach this but I will be
doing quarterly attendance reviews for our group. If
someone miss 0 days (or no occurrences) then they get
a "Premier" rating. Less than 3 occurrences "Excellent"
rating and so on. But the problem is if someone misses
consecutive days - (example) March 2 - 5 - then this will
only count as 1 occurrence. What is the best way to
approach this? I would like to create a query that I can
use in a report that will display the name of the person,
their rating (based on occurances) and number
of "Occurances" they have had in the past quarter.
 
You need two tables:

TblSomeOne
SomeOneID
FirstName
LastName
etc

TblAbsent
AbsentID
SomeOneID
StartDate
EndDate

If someone does not appear in TblAbsent they have no occurrences. For all others
just count how many times the specific SomeoneID appears in TblAbsent. The
number of days for any occurence will not matter, each occurence will only count
as 1.
 
Back
Top