Update Query with Time Criteria

  • Thread starter Thread starter hotplate
  • Start date Start date
H

hotplate

Hi,

I need help with an update query. I would like to update the shift to
either 1 or 2 depending on the time of day. The time field is in the
Date/Time formate so it would look like "2/5/2008 9:45:32 AM". I need
to update the shift to 1 if it is between 5AM and 5PM, and 2 if it is
between 5PM and 5AM.

Can someone help me with this query? Thanks in advance.

Garrett
 
Hi,

I need help with an update query. I would like to update the shift to
either 1 or 2 depending on the time of day. The time field is in the
Date/Time formate so it would look like "2/5/2008 9:45:32 AM". I need
to update the shift to 1 if it is between 5AM and 5PM, and 2 if it is
between 5PM and 5AM.

Can someone help me with this query? Thanks in advance.

Garrett
Click to expand...

In VBA help, look up the TimeValue function. Check the example.
 
Back
Top