Null #error

[Guest]

=[ProductCode] & " " & Trim([SkinDoorReplace] & " " & [Particular] & " " &
Left([Measurements],InStr([Measurements],"X")-2) & "mm X " &
Mid([Measurements],InStr([Measurements],"X")+2) & "mm")

If measurements is null , the above equation is #error
How to make it not #error when measurements is null?

Any solutions?

Thanks in advance

Kennykee

 

[Alex White MCDBA MCSE]

use the iif statement

bit of air code

iif(isnull(Measurements),0,Measurement)

but it would be better in the long run to make sure that the measurement
field never has null default the value to 0, would make your coding simpler.

 

[Guest]

Or
Nz(Measurements,0)

use the iif statement

bit of air code

iif(isnull(Measurements),0,Measurement)

but it would be better in the long run to make sure that the measurement
field never has null default the value to 0, would make your coding simpler.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

=[ProductCode] & " " & Trim([SkinDoorReplace] & " " & [Particular] & " " &
Left([Measurements],InStr([Measurements],"X")-2) & "mm X " &
Mid([Measurements],InStr([Measurements],"X")+2) & "mm")

If measurements is null , the above equation is #error
How to make it not #error when measurements is null?

Any solutions?

Thanks in advance

Kennykee