instead of doing this, how can I make this in SQL?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
Set rs = db.OpenRecordset("SELECT * FROM COMPUTER_LIST WHERE create_date > dateadd(day,10,date)")