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