Query stopped working

[AndyC121]

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.

[JamesDeckert]

>>DateSerial(Year(Date()),Month(Date())+1,0))
DateSerial takes a year, month and day. Why do you have 0 for the day?

[June7]

0 causes the calc to return last day of the month (28,29,30,31) as appropriate for the month.

What does 'stopped working' mean - error message, wrong results, nothing happens?

What do you mean by 'delete the query all records show' - delete query from where and show records where?

Don't see anything wrong with query.

If you want to provide db for analysis, follow instructions at bottom of my post.


Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

[JamesDeckert]

Thanks June, didn't see this in the documentation. I guess it makes sense.

Andy, if you change the dates in the table back, does the query start working again?