alexbeatle
New member
- Local time
- Today, 03:19
- Joined
- Sep 21, 2014
- Messages
- 9
Good day,
Can an SQL statement contain a VBA variable?
I'm trying this:
I want to add columns to table with names Categories1, Categories2, ...etc.
Thank you
Can an SQL statement contain a VBA variable?
I'm trying this:
Code:
DoCmd.RunSQL "ALTER TABLE tbl_outlooktemp ADD COLUMN 'Categories'&[Count] text;"
I want to add columns to table with names Categories1, Categories2, ...etc.
Thank you