I have a sql database that I have linked tables to in Access. I am trying to run a query on date ranges using either "between . . . and" or >= and <=, but the last day is not being included in the query.

Here is the criteria I have for the query.

Between [Forms]![frmbankrecreport]![From Date] And [Forms]![frmbankrecreport]![To Date]

I am using Access 2003. The source table that we are linked to has a datetime data type, so I am wondering if the problem is with the data type. Any suggestions on how to get this fixed?

Does the field that you are checking have time and the form input not,
A date quoted wiyhout a time defaults to a time of 00:00:00 and thus is less than any similar date with a time.
Try
...And [Forms]![frmbankrecreport]![To Date] + #23:59:59#


Brian

That was exactly the problem. Thank you very much!!

Been there done that, happy to pass on experience. :D

Brian

Good Call!

'experience' -- Is that like 'old age'?

Best wishes - Bob

Good Call!

'experience' -- Is that like 'old age'?

Best wishes - Bob
'experience' is positive
'Old age' is less so:D

Mind you some people I know have many years experience while others have 1 years experience many times;)