Access 2003

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

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
 
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
 
Back
Top