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]

You should bet the items that match the StartDate.

If the date field has a time component, you won't get the last date, so
specify less than the next day, i.e.:

= [Forms]![Form1]![StartDate] And < ([Forms]![Form1]![LastDate]+1)

It may help Access understand the dates correctly if you:
a) Set the Format property of both unbound text boxes on your form to Short
Date or similar.

b) Declare the parameters. In query design view, choose Parameters on the
Query menu, and enter 2 rows:
[Forms]![Form1]![StartDate] Date/Time
[Forms]![Form1]![LastDate] Date/Time

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

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!