View Single Post
  #1   Report Post  
SaraWitch SaraWitch is offline
Junior Member
 
Posts: 0
Default Text Form Field Calculation

Hello all,

I have a budget form where I want to calculate the expenditure and income, with a total of what's left. I have set up text form fields (E1 to E38 for expenditure which is on the first page and I1 to I8 which is on the second page), but they are not calculating. I have calculated on exit and have the following formulas in the Expression boxes:

Page 1 - E1 to E38

Page 2 - I1 to I8

Page 2 - Incoming (Expression =Sum(E1:E38))
Outgoing (Expression =Sum(I1:I8))
Total (Expression =Incoming-Outgoing))

I hope this makes sense! And I can't work out why it's not working! Any help would be greatly appreciated!

Ta muchly, folks!