As in:
cID = "NewField"
Alter table Jaar add column (cID) C(5)
will add a field called Newfield of type Character length 5
So will
Alter table Jaar add column &cID C(5)
As I said earlier, the problem is to make sure that the variable cID contains a valid field name. One that starts with a digit isn't valid.
Regards
Mike
Regards
Mike