Query Help

[MTSPEER]

Hey guys,



I have 3 fields I want to display. The name of the person[Name], Date Mailed[Date Mailed], and Date Received[Date Received]. I want to display the records that don't have information in them and only if it's been 30 days or more. I wrote this code here:

Select * from Sheet1
Where [Date Received] is NULL

But that only returns all the blank fields. I want to display the ones that are blank and have been 30 days or more..I want to keep the blank records within the 30 day period from the Date Mailed period.

[pbaldy]

Along the lines of:

Where [Date Received] is NULL AND [Date Mailed] > (Date() - 30)

[MTSPEER]

It works! Danke!

[pbaldy]

Happy to help, and welcome to the site!