Start Date and End Date problem

[abulfouz]

I am trying to run a query, in which i want to filter transactions between certain dates, so i have a Criteria
>= [Enter Start Date] And <= [End Date]

this prompts the user to enter the start date and end date..... but the problem i face is for the End date part it does not filter the date that is equal '=' it brings only whatever is less '<'



For example... if i asked for Start Date 10/01/2014 and end date 10/15/2014.... it brings data from 10/01 to 10/14 it does not show 10/15/2014

Please help

[qa12dx]

between [Enter Start Date] And [End Date]

[ssanfu]

Do the Start date and end date fields have a time included?
Something like 10/4/2014 08:00 AM

If so, then no dates > midnight would be returned for the last date.

[abulfouz]

I have tried the Between too it returns the same result...
no the dates dont have a time format.. short date and dd/mm/yyyy

[ssanfu]

Could you post the dB? What is the query name that is having the problem?

[orange]

In Access BETWEEN is inclusive so will retrieve
greater or Equal StartDate and Less or Equal EndDate.