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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating only changed records 7
Calendar reporting question 5
Can a report automatically update from a crosstab query? 2
Financial Year Query 1
Calculating transactions by time 3
Report - Query multiple columns 3
I need a mathematical thinker. 5
Automatically create action item 1

Back
Top