Clearing values from a table

[Julie]

I have a table I use for weekly figures. At the end of the week I transfer the figures to a database for year to date figures using a macro. Do you know a macro I can use to clear the table at the end of each week?

 

[Travis]

You can create a Delete query and use the macro to run this.

 

[Julie]

Thanks