Counting Records

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have a payroll query where field list are the days of the week with the
hours worked each day. Not every employee works every day of the week. I am
trying to add a field that counts how many days the employee has worked, not
the hours.
Is it possible?
My field names are MonHrs, TueHrs, WedHrs, etc
This could also be done in a report.
Annelie
 
If you tables were normalized then this would be a simple totals query.
However you might need to use an expression like:
DaysWorked: IsNull(MonHrs) + IsNull(TueHrs)+...5
 
It worked out very well, it gave me the number of days not worked as minus,
I added +7 to the formula and now I got the correct number of days,
Thank you,
Annelie
 
Back
Top