addition with 0

[peljo via AccessMonster.com]

My update function does not always work properly, especially when one of the
fields is 0 or blank.How could i improve my function so that when addding wih
0 not to give 0 ?

My function is the following:
Public Function dummy()
StrSQL = " UPDATE (products1 INNER JOIN products ON products1.Productid =
products.Productid) INNER JOIN [Order Details1] ON " & _
" products1.Productid = [Order Details1].productid SET products1.items1 =
[order details1].[quantity]+[products1].[items1]"
End Function

 

[John W. Vinson]

My update function does not always work properly, especially when one of the
fields is 0 or blank.How could i improve my function so that when addding wih
0 not to give 0 ?

My function is the following:
Public Function dummy()
StrSQL = " UPDATE (products1 INNER JOIN products ON products1.Productid =
products.Productid) INNER JOIN [Order Details1] ON " & _
" products1.Productid = [Order Details1].productid SET products1.items1 =
[order details1].[quantity]+[products1].[items1]"
End Function

Adding a 0 will always just do that - add a zero, and give the correct answer.

Adding a NULL will give NULL as the result. If one field may be null, use the
NZ (Null To Zero) function to convert it to a zero:

NZ([order details1].[quantity])+NZ([products1].[items1])