1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.WORD.DOC

  • Text Form Field Calculation

    From SaraWitch@21:1/5 to All on Thu Aug 27 15:05:53 2020
    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!




    --
    SaraWitch

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)