Create a new table each time...

[Guest]

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.

 

[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

 

[Guest]

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.

 

[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.

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.

 

[John W. Vinson]

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

Your boss was wrong. It often happens... <g>

John W. Vinson [MVP]