Hi
my attendance form is working with this dcount, however since datatype is not string for date in the dcount, the validation msgbox is not working.
here is the code
If DCount("[Employee]", "ClockInOut", "[Employee]='" & Me!Employee & "' AND [Status]='" & Me!Status & "' AND [DateTime]=#" & Me!txtDateTime & "#") > 0 Then
MsgBox "This employee already signed in."
please help
thank you