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)")