Using access 97, does anyone know how to have a macro run a query and save the data produced by the query in a table with the name "query 08/11/06" i.e. "query + currentdate"

thanks

You could just use an Append query, but then why would you want to?:confused: