Access 221.6 TI 16:57. I was using Access 2000 and have upgraded to Access 2007.

In this portion of the course material, we are setting up two input parameters for Field StartDate.

In the Criteria part of this field we are using "Between [StartDay] And [EndDay]". When I use this verbatim in my code, I get no results regardless of the time periods used. This is the same result for both Access 2000 and Access 2007. Digging into this a bit, I found:

The EndDay input criteria works as you show it; but I MUST enter "#Date#" in the StartDay input or the query does not work. This is differrent than what is shown in the video.

Although I didn't need to change the EndDay portion, to get around this Issue, I have changed the Criteria as follows:

"Between CDate([StartDay]) And CDate([EndDay])"

My example now behaves as shown.

---

Reply from Richard Rost:

That is very interesting. I'll have to try it. Thanks for sharing!