Results 1 to 2 of 2
2004-04-13, 19:14 #1
- Join Date
- Apr 2004
- 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
2004-04-13, 19:30 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 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
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.