MS Access, VBA Filter on Date field including Nulls
Posted on 2013-01-21
I have a form which I would like to filter on a date field, and the results to include any Nulls.
The code below returns 0 records, yet when I split the filter, the two halves work correctly.
Private Sub Btn_Filter_Review_1_Week_Click()
Me.Filter = "[last_reviewed_Date] <= DateAdd (" & Chr(34) & "m" & Chr(34) & ",-1,Date()) " _
& " AND [last_reviewed_date] is Null"
Me.FilterOn = True
Any help greatly apreciated.