Getting "datatype mismatch error" for Date

[daipayan]

Dear All,

I am in vain now. I had created a Access DB where there is a query named as "GenerateTimeHours", here whenever am trying to do a search by ID, Time & Date, always getting "data type mismatch error", I checked it and understand this Error is causing for Date Search Clause, I tried every possible way to change the date format, using #, etc etc but no result :banghead::

Query As follows:

SELECT GenrateTimeHours.ID, GenrateTimeHours.MaximumSeatsNumber, GenrateTimeHours.DaysInMonth, GenrateTimeHours.Hour, GenrateTimeHours.Remaining, GenrateTimeHours.FinalSeats
FROM GenrateTimeHours
WHERE GenrateTimeHours.ID = 1 and GenrateTimeHours.Hour between #08:00:00 AM# and #10:00:00 AM# AND (GenrateTimeHours.DaysInMonth) between #7/2/2013# AND #7/3/2013#;

Please help, for your reference am attaching the Database in the message.

Thank You,
Daipayan

 

[michaeljryan78]

THere was an error in DayNoQueries where the date was formatted as text. The result just trickled down through the outer queries. I have attached a resolution. I did not modify any data in the DB.