Results 1 to 2 of 2

Thread: Null values

  1. #1
    Join Date
    Dec 2004
    Posts
    4

    Unanswered: Null values

    Hi! All

    I have done a formula for total in a query. The formula gives me the result only if all the fields having a value. If one or more fields having null, the formula column is blank. Can anyone help me.

  2. #2
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    Have a look in Help for the NZ() function. It allows your formula to see nulls as zeros so the calculations will work.

Posting Permissions

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