Date Criteria

[ai_enjoi via AccessMonster.com]

Hi!

What criteria should be placed in the query so that it should look up
values in the field that start from Date1 to Date2. I have this criteria:
"Between [Forms]![Form1]![StartDate] And [Forms]![Form1]![LastDate]" which
only looks for values in between (I know, it only includes the values in
between the dates because of the 'Between', that's why I'm asking for help.)
the dates and not including the StartDate and LastDate. What should i put
instead of 'Between'?

Thanks for those who would help! Any help would be gladly appreciated!

 

[Allen Browne]

Answered in another group where you asked this q.