Hello everyone!
I keep getting these "broken" queries.
Code:
SELECT Account.Date AS Expr1, DatePart("m",[Date]) AS M, DatePart("yyyy",[Date]) AS Y, Account.Owner AS Expr2, Account.DBAmt AS Expr3, Account.CRAmt AS Expr4
FROM Account
WHERE (((DatePart("m",[Date]))<DatePart("m",[Forms]![AReports]![SDate])) AND ((DatePart("yyyy",[Date]))=DatePart("yyyy",[Forms]![AReports]![SDate]))) OR (((DatePart("yyyy",[Date]))<DatePart("yyyy",[Forms]![AReports]![SDate])));
Where it should be:
Code:
SELECT Account.Date, DatePart("m",[Date]) AS M, DatePart("yyyy",[Date]) AS Y, Account.Owner, Account.DBAmt, Account.CRAmt
FROM Account
WHERE (((DatePart("m",[Date]))<DatePart("m",[Forms]![AReports]![SDate])) AND ((DatePart("yyyy",[Date]))=DatePart("yyyy",[Forms]![AReports]![SDate]))) OR (((DatePart("yyyy",[Date]))<DatePart("yyyy",[Forms]![AReports]![SDate])));
I thought it was happening when I disconnected the backend from the front end, but that isn't the case (it happened without disconnecting as well). Has anyone had this experience? Is there a reason and/or solution? Is it corruption?
Thank you! Hope you're having a beautiful day!