Null Fields using NZ function

[BBBryan]

Hi,
I can't figure this out.
I want to add and convert by muliplying 3 fields together But some of the fields could be Null.
I have this but it doesn't work.
Length(InMeters): Nz(([Length(ft)]*0.3048)+([Length(mm)]*0.001)+([Length(m)]))


Thanks

 

[boblarson]

You need to encapsulate each field with NZ not the entire calculation:

Length(InMeters): (Nz([Length(ft)],0)*0.3048)+(Nz([Length(mm)],0)*0.001)+ Nz([Length(m)],0)

 

[BBBryan]

Thanks Bob,
That was easy. I must have missunderstood how the NZ Function works.


Bryyan

 

[boblarson]

You might want to check out this page about Nulls. There is a part about mathematical calculations (down the page a bit) and about aggregate functions which might be good to get a grasp on.

 

[BBBryan]

Thanks
I see that covers everything about nulls.