Totalling in Reports

[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.

 

[Guest]

Also I am rookie so I need alot of help. I was lucky to get this much working

 

[Duane Hookom]

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)