hi, need help to selcet this week data from access table bleow is the code i created which is not working. please hlep. strSQL = "SELECT distinct(loan_Number) FROM audit where Date_s >= BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 7 DAY ) AND...