straybullet
IS-IT--Management
Currently using:
Function Ceiling(ByVal iOne As Double, ByVal iTwo As Double)
Ceiling = Excel.WorksheetFunction.Ceiling(iOne, iTwo)
End Function
which works wonderfully - except (there's always the exception isnt there!) when the base price the ceiling function uses is a negative number.
According to Excel, the ceiling function would ordinarily display zero when the result is negative. What would be the proper way to tell Access 2K that when there is an error, to display a zero?
Let them hate - so long as they fear... Lucius Accius
Function Ceiling(ByVal iOne As Double, ByVal iTwo As Double)
Ceiling = Excel.WorksheetFunction.Ceiling(iOne, iTwo)
End Function
which works wonderfully - except (there's always the exception isnt there!) when the base price the ceiling function uses is a negative number.
According to Excel, the ceiling function would ordinarily display zero when the result is negative. What would be the proper way to tell Access 2K that when there is an error, to display a zero?
Let them hate - so long as they fear... Lucius Accius