Criteria

G

GOL

I posted this yesterday, received some help but still to no avail.

I'm attempting to run a query for a weeks worth of data. But, I only need
information from 2:00 and after on Monday 2/7/2005 (>=2:00:00 PM) till Friday
2/11/2005 up until 2:00 (<2:00:00 PM) All the data on Tuesday, Wed., Thurs.,
I need inclusive,these times don't matter. I've tried setting criteria with
dates and times, but can't seem to pinpoint the criteria I need. The date
and time fields are separate from each other (an order date and order time
field in query). I currently have a criterion set up that returns the
correct information with 2 consecutive days (After 2 on Monday and before 2
on Tuesday), but cannot figure one for more than one day as I specified
earlier. Any further suggestions are again appreciated as I am still
struggling w/it.
 
D

Doug M

If your dates and times are in separate fields, then you may need to combine
them in an expression in your query and then set a criteria for that
expression. You'll need an expression like:

TimeDate1: CDate([Date1] & " " & [Time1])

Then for that expression add a criteria like >#2/7/2005 14:00# and
<#2/11/2005 14:00# or something.

Doug M
 
V

Van T. Dinh

You should post follow-up question in the same thread, not different thread.

What's wrong with Douglas' last reply?
 
Top