On a form there are two date/time fields. The first field is sign-in and the second is sign-out. Both fields use the Now()function to get the user sign-in and sign-out times. Obviously, the form gets used at the beginning of the workday and the end of the workday.
Sometimes a user gets confused, etc. and selects the wrong command or forgets to sign-in, but will sign-out.I need someway to "find" those occasions....I'm trying to build a query to check for these exceptions.
But when I run a query with [SignIn] and [SignOut], I sometimes get something like this:
[SignIn] [SignOut]
Jones 1/21/2004 8:30 A.M. 'nothing here
Smith 'nothing here 1/21/2004 5:00 p.m.
And then if I try to use any date/time functions, the empty spaces get filled with #Error.
What's in the blank spaces (remember I'm using Now() to get my date/Time)
Is there away to correct this?
Sometimes a user gets confused, etc. and selects the wrong command or forgets to sign-in, but will sign-out.I need someway to "find" those occasions....I'm trying to build a query to check for these exceptions.
But when I run a query with [SignIn] and [SignOut], I sometimes get something like this:
[SignIn] [SignOut]
Jones 1/21/2004 8:30 A.M. 'nothing here
Smith 'nothing here 1/21/2004 5:00 p.m.
And then if I try to use any date/time functions, the empty spaces get filled with #Error.
What's in the blank spaces (remember I'm using Now() to get my date/Time)
Is there away to correct this?