Inserting Var into SQL

[Zeroanarchy]

Hi all,

I have tried different variation of this but I can not seem to get it to work.

Var t_name
t_name = tablename & Date

'DoCmd.RunSQL "CREATE TABLE t_name ([Product Code] TEXT, [Product Name] TEXT, [Cost] CURRENCY);"

Thanks for your help in advance.


ZeroAnarchy
Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.

 

[PHV]

Perhaps this ?
DoCmd.RunSQL "CREATE TABLE [!][" & [/!]t_name [!]& "][/!] ([Product Code] TEXT, [Product Name] TEXT, [Cost] CURRENCY);"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zeroanarchy]

THanks PHV for your help, worked great.

ZeroAnarchy
Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.