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?

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

Thanks