Using Nz Function To Return a Zero

[jaaret]

Is there a way for the Nz function return an integer rather than a string?

=Nz(EndTime-BeginTime,0)

The above expression returns a zero as a string (aligned left) rather an an integer.

 

[Ed2020]

Not on my PC it doesn't! I thought NZ returned a variant, so you can return whatever value/type you want.

You could try explicitly casting to an integer:

=CInt(Nz(EndTime-BeginTime,0))

Ed Metcalfe.

Please do not feed the trolls.....

 

[jaaret]

Perfect! Thanks! Much easier than the Iif function.

Cheers!