Hello everyone,
Im currently working on a database, and im trying to filter on when a checkbox is marked as false; however the filter only works on true. When changing to false, it gives me a invalid call procedure.
This is my SQL if it helps:
Any help would be appreciated!
Im currently working on a database, and im trying to filter on when a checkbox is marked as false; however the filter only works on true. When changing to false, it gives me a invalid call procedure.
This is my SQL if it helps:
SELECT tblBoxNumbers.ID, tblBoxNumbers.IronMountainID, [tblRecord Departmenttype].RecordType, tblDocumentTypes.DocType, tblBoxNumbers.[SenttoDestroy?], tblBoxNumbers.EmailsentDate, DateAdd("yyyy",[tblDocumentTypes]![Years],[tblBoxNumbers]![DocumentDate]) AS Expr1, tblBoxNumbers.DocumentDate
FROM [tblRecord Departmenttype] INNER JOIN (tblDocumentTypes INNER JOIN tblBoxNumbers ON tblDocumentTypes.DocumentTypeID = tblBoxNumbers.DocumentTypeID) ON [tblRecord Departmenttype].RecordTypeID = tblBoxNumbers.RecordTypeID
WHERE (((tblBoxNumbers.[SenttoDestroy?])=True) AND ((DateAdd("yyyy",[tblDocumentTypes]![Years],[tblBoxNumbers]![DocumentDate]))<Date()));
Any help would be appreciated!