Using a For Next Loop to add Fields to a Table

[harrisw]

I'm using the code below

For x = 1 To 10
DBase.Execute "ALTER TABLE Results ADD COLUMN TEST(x) TEXT;"
Next x

Keep getting syntax errors.

Any ideas?

 

[Jacob Mathai]

try

DBase.Execute "ALTER TABLE Results ADD COLUMN TEST " & x & " TEXT"

 

[Jacob Mathai]

Correction :
DBase.Execute "ALTER TABLE Results ADD COLUMN TEST" & x & " TEXT"