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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing constants in a query to user input values 2
Date/Time Calculations In Query After Midnight 3
MS Access Date/Time Calculation After Midnight 1
making a table with a query 2
Calendar display problems 4
Shift wise Totals 3
comparing times 2
IIF update query with Between Criteria 5

Back
Top