I am trying to delete all information within table before, replenishing it with new data.
I've tried using TRUNCATE at the beginning of the coding to empty my Table before replenishing, using an action button SQL QUERY (dtReportAssess = Table name)
truncate Table dtReportAssess ;
And have been getting an error.
near "truncate" : synax error.
Any suggestions and any help would be great.