Hello friends,
i have the following syntax in my query:
WHERE (((tblMaintenanceActions.FinishedDate) Between Date() And Date()+30) AND ((tblMaintenanceActions.Completed)=False)) OR (((tblMaintenanceActions.AApproval)=False)) OR (((tblMaintenanceActions.BApproval)=False));
I want to view the next 30 days records which must be or completed, or A approved or B approved.
With this syntax, i get records more than 30 days (ex april 2020).
Any idea?
i have the following syntax in my query:
WHERE (((tblMaintenanceActions.FinishedDate) Between Date() And Date()+30) AND ((tblMaintenanceActions.Completed)=False)) OR (((tblMaintenanceActions.AApproval)=False)) OR (((tblMaintenanceActions.BApproval)=False));
I want to view the next 30 days records which must be or completed, or A approved or B approved.
With this syntax, i get records more than 30 days (ex april 2020).
Any idea?