Re: Query for all recs Between 7/10 at 2:PM and 7/12 at 6 PM ???

Doug,

Thanks VERY much.....

I even added an Nz default entry function provided by Allen and Duane...
http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/33188/DEFAULT-Value-in-a-Query-PROMPT-Criteria-type#62d8bdc2cf5bduwe

....to make it super user friendly.

It's now....

WHERE ((([StartDay]+[StartTIME]) Between (CDate(Nz([Enter FROM Date as mm/dd
(press ENTER for today)],Date()))+CDate(Nz([Enter FROM Time as hh:mm am/pm
(press ENTER for entire day):],"1 AM"))) And (CDate(Nz([TO Date (ENTER for
Today)],Date()))+CDate(Nz([TO Time (ENTER for Entire Day)],"11:49 PM")))))

Hard to read....but it works.

THANKS !

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200607/1
.