Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Southeastern Ohio
    Posts
    4

    Unanswered: Calculations do not work- Help!

    Working on 7000 record database. Up to 5 New license numbers apply to each record. each Lic. Number costs $9.00 per. All number fields in structure are "Number" Properties set to "Currency, When I make a field to total numbers such as =[1afee]+[2afee] numbers add to $18.00, when I put an additional field calc on such as =[1afee]+[2afee]+[3afee] the field now is blank, will not add the third on. Wanted to add the 5 fields together on Report and on Form. If one license purchased, $9.00 shows, If two licenses purchased $18.00 shows, If three - $27.00 shows, etc. Why does the two show and add, and the third or more just shows a blank. Most people buy one "Dog License" some buy 2, some 3, some 4, a few buy five. I wish the input form to echo the amount of fees she has entered so by eye, they will know they entered the proper amount of dollars. Can justify cash drawer at end of day this way. Holds down input user error visually.

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326

    Calculation

    Most likely, you are adding a null to your sum set when you add your third field.

    Try Nz([1afee], 0) + Nz([1afee], 0) + Nz([3afee], 0)...

    Mike.
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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