Make table query - with date in table name (1 Viewer)

[jomuir]

I have used/am using the "INTO tbl_temp_copy" to create a temp table from a query called tbl_temp_comp. Everytime I run my query it deletes and then creates a new table with the same name - and this is what I have been wanting.

However now I would like to create a table with the date in the table name so:- "INTO tbl_temp_copy_Date()" but obviously this does not work and I do not know if it is even possible?

Anyone able to do this or know that it cannot be done?

 

[Rabbie]

Try something along these lines

"INTO tbl_temp_copy_" & Date()

or

"INTO tbl_temp_copy_" & format('dd-mm-yyy',Date())

You may need to do some tweaking so good luck!

 

[Number11]

I know this is an old post but did anyone get this working as i need to do the same create a a table with todays date within the title?

 

[Gasman]

Can't you just use 260924 ?

 

[plog]

Did you try Rabbie's suggestion?

What exactly did you try?

 

[Gasman]

Have to think it is not a great idea anyway?, as opposed to the table with a date to show when records were added?