R
Robert
I have three fields in the details of a report. Hrs Wked, Lv Hrs, Extra Hrs.
Each field represents an employee's work schedule for a particular pay
period. At the Employee Footer of the report, I have a total of Hrs Wked, Lv
Hrs and Extra Hrs. I now wish to create a text box that sums up ALL three
sums and to title that TOTAL HRS.
However, i tried =sum([Hrs Wked])+sum([Lv Hrs])+sum([Extra Hrs]). If ONE
of the summations has no entry, it does not add at all. I tried Group but
still no joy.
Microsoft help says you can not do this sum as : para 207733 (I think)
I understand that ACCESS does not hold these report footer sums and this is
why i can not add them.....but i have a hard time believing that.
How may i calculate ALL 3 sums?
Robert
Each field represents an employee's work schedule for a particular pay
period. At the Employee Footer of the report, I have a total of Hrs Wked, Lv
Hrs and Extra Hrs. I now wish to create a text box that sums up ALL three
sums and to title that TOTAL HRS.
However, i tried =sum([Hrs Wked])+sum([Lv Hrs])+sum([Extra Hrs]). If ONE
of the summations has no entry, it does not add at all. I tried Group but
still no joy.
Microsoft help says you can not do this sum as : para 207733 (I think)
I understand that ACCESS does not hold these report footer sums and this is
why i can not add them.....but i have a hard time believing that.
How may i calculate ALL 3 sums?
Robert