Date Query

[Les]

Hello

I'm trying to build a query that shows me all records where a field is older
than 90 days from today or are null.
I've tried using <Now()-"90" Or Is Null but this doesn't give the desired
results.
What am I getting wrong?

Thanks

 

[John Spencer]

Assumption: Your field is a date field

Field: YourDateField
Criteria: Is Null Or <DateAdd("d",-90,Date())

Or try dropping the quotes in your expression so it reads

Field: YourDateField
Criteria: <Now()-90 Or Is Null

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Les]

Cheers John

Worked a treat.

Les.

Assumption: Your field is a date field

Field: YourDateField
Criteria: Is Null Or <DateAdd("d",-90,Date())

Or try dropping the quotes in your expression so it reads

Field: YourDateField
Criteria: <Now()-90 Or Is Null

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..