Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing field calculations on Joined tables (Access 2002)

    I joined two tables and created a calculated field to add one field from one table and one from the other. Pretty straightforward. But for for all those records that don't match, the calculation is not taking place, its a blank cause one half of the equation is blank. What can I do to make the calculation still take place? I am simply adding one field to the other, if the other is not there I still want to carry the value across to the calculated total column. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing field calculations on Joined tables (Access 2002)

    Welcome to Woody's Lounge!

    Null (blank) values will cause all calculations involving them to return Null. You can use the Nz function to replace Null values by something else, in this case by 0. Instead of [SomeField], use

    Nz([SomeField],0)

    in your calculation. If that is not clear enough, please provide some more detail about the fields involved in your calculation, so that we can give more specific help.

Posting Permissions

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