Query Criteria help

[hmongie]

I need help creating a time criteria for a query. What I would like to do is create a time criteria where the query will retrieve data from a table from the previous date and the current date within a particular time frame.

what I have now (which doesn't work)...

Between <previous date> #11:00:00 PM# And Date()#7:00:00 AM#

Any help would be appreciated!!! Thanx!

 

[coyotem78]

Hiya

You'll have to put in the full date, if you want records from the previous and current dates.

HTH

coyotem78

 

[hmongie]

Could you give me an example?

 

[coyotem78]

Using u'r example and today's date

Between #11:00:00 PM# And Date()#7:00:00 AM#

would become

Between #5/22/2003 11:00:00 PM# And #5/23/2003 7:00:00 AM#

 

[hmongie]

Will the date always be current?
What I had in mind was to be able to print out a report that have records form the day before to the current day. This should change as the day changes. If I was to place a full date in such as 5/22/2003 then the next day, I would not be able to print the current report as I need to.

If you can help me let me know?

 

[Russell Hauf]

This should work on any date you run it:

Between Date()-1+TimeSerial(23,0,0) And Date()+TimeSerial(7,0,0)

The 23 in TimeSerial represents 11 PM.

HTH,

Russell

 

[hmongie]

Hey there Russell,

It works on the Date Criteria but the time from the following day does not come up... What should I put in the time criteria? Thanks for helping out on this issue....

 

[Russell Hauf]

Sorry, I'm not following what you are asking...