how to handle a null field

[fishhead]

Can someone tell me how to add two fields together when one of them is null?



I'm looking to calculate my profit from my buy and sell fields
some buy fields will be empty (null) and this seems to prevent me from using the following expression in my query GP=[sell]-[buy]

As long as there is a value in the buy field (even if the value is "0") the expression works well. unfortunately i can't update date all the null records to 0

is there a work around?

[Bob Fitz]

GP=Nz([sell],0)-Nz([buy],0)

[Bob Fitz]

GP=Nz([sell],0)-Nz([buy],0)

Or more correctly, as a calculated field it would be:
GP:Nz([sell],0)-Nz([buy],0)

[fishhead]

Great thanks!

[Bob Fitz]

Great thanks!

You're welcome. Glad to help

[ranman256]

I use NZZ(field):

Public Function Nzz(ByVal pvAmt)
On Error Resume Next
Nzz = Val(Nz(pvAmt, 0))
End Function

save on those stupid zeros.