Tabel query. Table name include systemdate and time.

[swedni]

Hello,

I am running Access 2013.

I want to run a table query and table name I want is "Tabell1_ + NOW ()"
Examples :. Tabelle1_05/05/2015 00:05:03

Is this possible?



//Dennis

[CJ_London]

only in vba to create a maketable query - something like

currentdb.execute("select myquery.* INTO [Tabell1_" & now() & "] FROM myquery")

you will need to use square brackets because of the spaces generated

[ranman256]

Select "table1" & now() as Fld from table1

[swedni]

Hi, Thanks for the help.