Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    86

    Unanswered: subtraction of feilds on a form

    Im have 4 feilds. Now i want to subtract all them.
    the format for the number is 0000003000, but sometimes could be 0000000500 but will always be 10 bytes long. How can i subtract these feilds

    they are allowed-deduct-other-new


    i used this but only works with two feilds

    Format(Val([CFR_ALLOWED])-Val([CFR_DEDUCT]),"0000000000") AS [Form Total],


    Thanks much help needed

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    deduct first the needed fields, then use the formatfunction on the result

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •