Hi
I have an update query that writes time value from an unbound field into a date data type field of a table. I don't know how to write the statement so the query knows it is only writing the time portion of the date data type into a date field.
Here is my SQL statement:
strSQL = ("UPDATE tblClass SET [StartHour]=" & Me.txtStartHour & " WHERE [ID]=" & Me.txtClassID & "")
[StartHour] is a date field in the table, and txtStartHour has an input mask of (HH:MM AM/PM).
Thanks in advance.