Unanswered: Query For Records Older Than 32 Days, Access 2007
I have a table (tblEnvDoc) that has two date fields: DateReceived and DateApproved. I want to run a query that will show those records that are greater than 32 days between DateReceived and DateApproved. If DateApproved Is Null, then I want to count 32 days from DateReceived. It seems like it should be simple but I'm not seeing it yet. Can anyone help. Thanks in advance.