Need help with one of my Time Clock forms (2 Viewers)

[arnelgp]

if there is no clockOut, what do you like to do with it? or maybe create a Default of clockOut same as clockIn value?

 

[arnelgp]

you need to copy from the attached db:

Query: TCQuery
Form: TimeClockReport
Function: CalcTotalHrsMin() (Modified in ModuleDay)

 

[Gasman]

Use the NZ() function.

 

[Technics]

you need to copy from the attached db:

Query: TCQuery
Form: TimeClockReport
Function: CalcTotalHrsMin() (Modified in ModuleDay)

Hey arnelgp. Don't want to keep bothering because your help is great. The error does seem to be fixed unless I close the program and reopen several times the error reappears in report. I am testing doing occasional clock ins with no clock outs and testing report in between them. This is when the error happens. I know there may not be as many no clock outs as I am testing with but it only takes a few and I'm sure I'll see them.