Running sum in a report

[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

 

[Fons Ponsioen]

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

 

[Jacob]

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?

 

[Duane Hookom]

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])