Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: calculation to assume null = 0

    I want to perform some calculations between two tables. But not all fields have numbers. Some are blank.

    Whats the best way have the query assume null = 0?

    Or can I?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try the nz() function.
    Paul

  3. #3
    Join Date
    Sep 2006
    Posts
    162
    Thanks, works like a charm.

Posting Permissions

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