Running sum in a report

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I am having troubles creating a calculation in a report. I have gone through
the help files step by step and it is not totaling a text field I have
listed in a report. Does anyone know what I may be doing wrong? Here is
some sample data.....


Current Year Vacation Date Date to PTO Sick Comp
Notes

1 2003 1/9/2003 1/9/2003 8
Personal Day Off.

2 1/20/2003 1/20/2003 8
Doctors appt

3 2/21/2003 2/21/2003 8
Sick
 
Jacob, Can you describe a bit more as to what you are
trying to calculate and how you have tried it so far.
maybe I can give you some suggestions as to which way to
go.
Fons
 
In the sample data below, I have Sick time, comp time and PTO time that I
need to total at the bottom for each person, the way I have the report
sorted by. At the end of that, I need a total of all time taken off for each
category. Does this help?
 
If you have numeric field like [Sick], [PTO], & [Comp] all you should need
in group and report footers is text boxes with control sources of:
=Sum([Sick])
=Sum([PTO])
=Sum([Comp])
 
Back
Top