Function in Access VBA?

[VBUser77]

Is there a function in Access VBA that converts a negative value to 0. I know there is a NZ function that converts null values to zero. I am just wondering if we have a function that converts negative values to zero.

Thanks a lot in advance.

Jay

 

[PHV]

One way:
IIf([TestField] < 0, 0, [TestField])
Another way:
[TestField] * -([TestField] > 0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[VBUser77]

Thanks a lot