Between [Enter begining date] And [Enter ending date]

[ty]

What expression should I use in order to include the
ending date as well. Right now it must be defaulting to
12:00:01 AM so it does not include the ending date records.

 

[Rick Dunmire]

Hello Ty,

Try this.

WHERE (((WhatEverTable.field_to_check) Between [StartDate] And [EndDate]));

Rick.

 

[Allen Browne]

Try:

(>= [Enter beginning date]) AND (< [Enter ending date] + 1)

 

[Guest]

Thanks This worked, but I had to remove the < sign.