I can't seem to find the problem and this seems like something you should be able to do but I'm obviously violating some rule or don't have the right syntax since it's not working.
I have set up a text box in the subtotal footer called Hrsworked. The Control Source for this field looks like this and it works fine:
Hrsworked =IIf([pthrssum]>0,[pthrssum],[reghrs])
I have two other textboxes in this subtotal that calculate pthrssum and reghrs and they are working fine.
In my Report total I want to total up all the hrsworked from all the subtotal footers so I have coded it as such:
Regtot =Sum([Hrsworked])
Instead of summing up the hours of Hrsworked from my Subtotal footers, It prompts me for the parameter Hrsworked when I try and execute the report. I've checked spelling and its the same. What am I doing wrong?
Shan
I have set up a text box in the subtotal footer called Hrsworked. The Control Source for this field looks like this and it works fine:
Hrsworked =IIf([pthrssum]>0,[pthrssum],[reghrs])
I have two other textboxes in this subtotal that calculate pthrssum and reghrs and they are working fine.
In my Report total I want to total up all the hrsworked from all the subtotal footers so I have coded it as such:
Regtot =Sum([Hrsworked])
Instead of summing up the hours of Hrsworked from my Subtotal footers, It prompts me for the parameter Hrsworked when I try and execute the report. I've checked spelling and its the same. What am I doing wrong?
Shan