I have two tables: Calibrated Equipment and Maintenance and cleaning. All was working fine on my queries then Monthly calibrated equipment query stopped working. Nothing had changed except a couple of dates in the table which were updated.
Here is my query: SELECT [Calibrated Equipment].ID1, [Calibrated Equipment].[Equipment Description], [Calibrated Equipment].[Serial No:], [Calibrated Equipment].[Last Done Date], [Calibrated Equipment].[Due Date], [Calibrated Equipment].[Place of Storage], [Calibrated Equipment].Comments, [Calibrated Equipment].[Contractor or Replace]
FROM [Calibrated Equipment]
WHERE ((([Calibrated Equipment].[Due Date]) Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date())+1,0)));
If I delete the query all records show okay? any idea's what has changed or gone wrong.