Access 2003

[Robert Raley]

I am having problems with my report and doing a summary. I will explain
what I have so maybe someone can explain to me what I need to do.

Section : Stage_name Header

Section: Mod_trans_dates Header
Text Box [tot_min_pay]
Text Box [tot_shift_pay]

Section: Detail
Text Box [add_pay]
Text Box [ded_pay]

Section: Mod_trans_dates Footer
Text Box [tot_add_pay] (Thjis is calculated)
Text Box [tot_ded_pay] (Thjis is calculated)

Section : Stage_name Footer

Now this is what I want to do. Have a text box that shows the grantotal like
of =[tot_min_pay]+[tot_shift_pay]+[add_pay]+[ded_pay]

When I do this it returns a blank

However when I do this =[tot_min_pay]+[tot_shift_pay]

It returns the total of the two feild correctly.

Thanks for your help in advance.

Bob


Page Footer

 

[Guest]

Robert. Rather than refering the names of the data fields in the detail
section do you not intend to have the formula be:
=[tot_min_pay]+[tot_shift_pay]+[tot_add_pay]+[tot_ded_pay]
Make sure there is a value for each of the variables, so instead of null (no
entry) make it a 0 (zero).
Hope this helps.
Fons