Time

[ICS]

I am building a Time card db and have run into a problem, my fields are Sun_in then Sun_out and so on. i put a total at the end of the form and set up the expression builder as so
([Mon_Out]-[Mon_In])+([Tue_Out]-[Tue_In])*24
The problem is if on of the fields is blank the total will be blank, can anyone help

 

[pbaldy]

You can try wrapping each field in the Nz() function:

Nz([Mon_Out], 0)

more info in help.

 

[ICS]

Thanks that really worked great

 

[pbaldy]

No problem, and welcome to the site by the way!