Create a new table each time...

B

Bill_AZ_FCU

Is there a way to have a query create a new table each time it runs without
having to interact with it?

For example: I set up a macro to automatically run the "export" query each
day at 10am and want to have it run again tomorrow without overwriting the
table.

Any examples would be greatly appreciated.
 
J

Jeff Boyce

I'm confused...

You can export the results of a query without creating a table. Are you
using a Make Table query? If so, why?


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

Bill_AZ_FCU

Because my boss told me to... ;0)

Yes make table query. I am open to exporting the data as long as we could do
it daily as different files automated.
 
P

pietlinden

Because my boss told me to... ;0)

Yes make table query. I am open to exporting the data as long as we could do
it daily as different files automated.
Click to expand...

Export the query instead of the table. Just use a function to
determine the date range you want. You can use TransferSpreadsheet
and that should do what you want.
 
Top