Query is not running in MS Access 2007....
Below query is running in MS Access 2007. But It shows the blank output. It doesn't show any record even if it has some record in range of Date. Why?------------------------------------------------
SELECT * FROM EmpDetail WHERE JoinDate BETWEEN #03/01/2017# AND #08/01/2017#;