I am trying to transfer my delete query from access query builder to VBA to hardcode it and am having problems , I think the compiler isn't happy with "Date < Date -60" but not sure how to make the compiler happy on this one, I have even tried declering date as a string stdate and that didn't seem to help
[VBA]
DoCmd.RunSQL "Delete IndividualSettingsTbl.Date" & _
"From IndividualSettingsTbl" & _
"WHERE IndividualSettingsTbl.Date < Date - 60;"
[/VBA]