Date search results wont include selected dates.

[UserJohn7673]

Hi all,

using access 2010...

I'm using following date search criteria

>=[Forms]![ReportsMenuF]![StartDate] And <=[Forms]![ReportsMenuF]![EndDate]

but if I enter 16/9/12 as start date and 16/9/12 as end date it won't list the records for 16/9/12. To do so i have to enter 15/9/12 as start and 17/9/12 as end. Is there a way to include the date selected in the start and end text boxes.

I'm reasonably new to access to please excuse my ignorance.

Any help would be greatly appreciated.

Cheers.

[Bob Fitz]

Not sure, but you could try:
>=DateAdd("d",-1,[Forms]![ReportsMenuF]![StartDate]) And <=DateAdd("d",1,[Forms]![ReportsMenuF]![EndDate])

[orange]

If you use the Between And construct, Access will include the end points by default.

It's possible you have included a time component in your Dates, and that can be a reason for not including a date.

[UserJohn7673]

Thanks for your suggestions and as soon as I get time I will try them out.

As for the 'Between' & 'And' constructs.. I used them originally and that didn't work either, but it may be because originally I did use date and time as the original properties but later changed it to Short Time. The time values may still be lurking in there although they are not displayed in the table.

Thanks again.