Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Private Sub cmdProcess_Click() 'Date_DateFellDuringLast30Or31Days Dim SQL SQL = "DELETE Table1.SalesDate FROM Table1 " SQL = SQL & "WHERE((Table1.SalesDate) Between Date() And DateAdd("m"-1,Date()));" CurrentDb.Execute SQL, dbFailOnError MsgBox "Complete", vbOKOnly, "Process Complete" End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Reports issues going from Access 2003 to Access 2013||14||57|
|MS Access How To Run a Macro From Task Manager...Not With AutoExec...I Need To Call A Public Sub||3||41|
|Email Excel WB by selecting name from a dropdown list to Outlook.||5||36|
|Could someone write me an SQL query for MS Access?||4||24|