better
03-13-2006, 08:42 AM
Can anyone tell me how to use a Datediff function in a field lookup? I've managed to do this on a form, using this code:
Private Sub TimeOut_Exit(Cancel As Integer)
Me![Hours] = (DateDiff("n", Me![TimeIn], Me![TimeOut])) / 60
End Sub
Problem is this table will be being populated over the web via ASP.
Thanks in advance!
Bart
Private Sub TimeOut_Exit(Cancel As Integer)
Me![Hours] = (DateDiff("n", Me![TimeIn], Me![TimeOut])) / 60
End Sub
Problem is this table will be being populated over the web via ASP.
Thanks in advance!
Bart