recording start & stop times

M

Michelle

I posted a question regarding this previously but can not see it in any
discussions and I have had replies.
Can anyone enlighten me??
 
A

Arvin Meyer [MVP]

I think your quotes might be messed up. Try this one. Add a debug.print
statement and see what shows up in the Immediate window, then copy and paste
that into a query window. Once it's right the query should show the correct
data.

strSQL = "Insert into tblJobTimes(TimeStartJob, TimeStopJob)Values (#" &
dteStartJob & "#", "#" & dteStartJob & "#");"
Debug.Print strSQL
 
Top