Greetings All
I'm trying to create an expression in an Access calculated field to reflect 0.00% when either of the two fields included in the function are zero
My current attempt is as follows:
As I'm sure you can ascertain - my two fields are: PluggedIn & SignedInTimeCode:IIf(Or([PluggedIn] = 0, [SignedInTime] =0),0,([PluggedIn]/[SignedInTime]))
I have also tried IfError / IsError & Nz
Thank You so much for any help