work hours vs home hours

  • Thread starter Thread starter V. Terry
  • Start date Start date
V

V. Terry

I'm trying to query a data file to separate out entries
which fall during school hours from those after school
hours.

My only idea how to do this is a criteria naming all hours
between 7:30 am and 3:30pm, but then the weekends are
different, and I believe I'll have to call out every date
separately with it's own time parameters.

Is there a better way to do this?

Thanks in advance - V Terry
 
You could look for the "day" date part of the date field and say if it is
Saturday or Sunday then do one thing, if it is not Saturday or Sunday, then
do something else.

Will holidays make a difference? What about summer?

Rick B


I'm trying to query a data file to separate out entries
which fall during school hours from those after school
hours.

My only idea how to do this is a criteria naming all hours
between 7:30 am and 3:30pm, but then the weekends are
different, and I believe I'll have to call out every date
separately with it's own time parameters.

Is there a better way to do this?

Thanks in advance - V Terry
 
Yes, holidays and summer are all different of course, but
your suggestion cuts down the problem significantly. Thank
you for your input.

V Terry
 
Back
Top