acess 2007 - how to handle nulll values

[jker]

I have text box(InvB4Tax) with an expresion of l1cost+l2Cost+L3cost. my problem is that any of those values can be null.

How can i test each value for null. If it is null replace with a numeric zero

<------ this is my expression to calculate value of INVB4Tax



<------ this is my text box that will contain the sum of l1cost+l2cost+l3cost

[CJ_London]

Use the nz function to substitute 0 for null

Nz(l1cost,0) + nz(l2Cost,0)+etc

[ranman256]

i shortened it to NZZ so i dont have to add the dang zero,( esp in queries), then its: NZZ(l2Cost)

paste into module:

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