need help to extract this week data from access table

[jagu147]

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

regards,
jayesh
​

 

[Joe4]

DATE_SUB and CURDATE() appear to be MySQL function, not Access functions.
If you tell us the exact logic you want to apply, we may be able come up with Access query that works for you.