Totalling in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called timesheets. I have 14 fields for the days of the
timesheet plus I total those all up on a form. I have a field for the pay
period ending date, the employees name and a Job #. I want to print a report
with just the totals for the pay period of each employee. Each employee
might have 3 or 4 different records because they work on multiple jobs. The
amount of employees will also change. I want one report that prints all
employees that worked and there total time.
 
Your table structure isn't normalized. However, you could use something like
the following in your query:
TwoWeekTotal: Day1+Day2+Day3+...Day14
If you might have Null (no value) in any of these fields, you will need to
use something like:
TwoWeekTotal: Nz(Day1,0)+Nz(Day2,0)+...Nz(Day14,0)
 
Back
Top