Hi sir,
How to select the records between two dates in msaccess. I need query for that.I executed the below query, it shows datatype mismatch error.
Query:
**********
select * from Checkinout where CheckTime between '2011-13-06' and '2011-06-14'
[Hint: CheckTime belongs to datetime datatype in ms-access]
With regards,
J.Prabu.
[Email:prbspark@gmail.com]