Add Date to Table Name - Make Table Query

[FireGeek21]

How can I add a date (2013-02-22) to the table name when running a make-table query thru a macro or VBA?

Thanks!

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)

 

[dhookom]

I don't think you can use an expression in the "made" table name. You could use a little DAO code to modify the SQL property of your saved make-table query.

Duane
Hook'D on Access
MS Access MVP