Time limits on query

  • Thread starter Thread starter DAN
  • Start date Start date
D

DAN

I need to query my table and limit it to either 7p-7a the following day
(night shift results) or 7a-7p the same day (day shift results. My problem
is I am getting no results when using "between". I have also tried <, >...
Any suggestions? I also tried combining date and time in an expression to
make the overnight calculation work, but still got nothing. Any help would
be greatly appreciated!
 
Not enough information. What fields in your query determine the shift? What
fields are you using in your attempt to limit the rows returned and what are
the field types?

Also, it helps if you post the SQL text of the query you are trying to use.
Often that makes it easy for a responder to give you a specific answer.
 
Back
Top