display above spicific day in SQL using access and vba

Code:

---


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?

Code:

---

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

---

Code:

---

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

---