J
Joanne
Hello,
I have a subform which keeps track of vacation days that employees have
requested. Each line in the subform has a begin date and an end date field.
At the end of each line is a text box, which is called txtTotalDays and it
totals the amount of days on the line.
At the bottom of the form (but still in the details section), I have another
text box that is supposed to total all the date counts in each txtTotalDays
box. The formula that I have in this text box is
=Format(Sum([TxtTotalCount]),"d"). I have also tried it in the footer but I
understand that calculated fields cannot be put in footers. I've tried it
without the format command, just the sum. Any way I try it, I get an error.
Can you tell me what I'm doing wrong?
Thank you for your help.
I have a subform which keeps track of vacation days that employees have
requested. Each line in the subform has a begin date and an end date field.
At the end of each line is a text box, which is called txtTotalDays and it
totals the amount of days on the line.
At the bottom of the form (but still in the details section), I have another
text box that is supposed to total all the date counts in each txtTotalDays
box. The formula that I have in this text box is
=Format(Sum([TxtTotalCount]),"d"). I have also tried it in the footer but I
understand that calculated fields cannot be put in footers. I've tried it
without the format command, just the sum. Any way I try it, I get an error.
Can you tell me what I'm doing wrong?
Thank you for your help.