display above spicific day in SQL using access and vba

[atzdgreat]

Set rs = db.OpenRecordset("SELECT * FROM COMPUTER_LIST")
If rs.RecordCount = 0 Then
Else
With rs
DateDiffValue = DateDiff("d", CDate(!created_date), Date)
If DateDiffValue > 10 Then
'Display Here
End If
End With
End If


instead of doing this, how can I make this in SQL?


Set rs = db.OpenRecordset("SELECT * FROM COMPUTER_LIST WHERE create_date > dateadd(day,10,date)")

[yujin]

SELECT * FROM COMPUTER_LIST WHERE datediff('d',now,create_date) > 10