A
ankush
Guest
hi all,
Can any one help me
I am working in ms Access2000
In access I have made some tables now i want to alter one table
This table is having multiple fields now i want to write a query through which all the fields(columns) gets altered
e.g
I have a table say Test with fields houseno ,age
Now i want to add some new fields Ph no and Fax
For this thing i wrote a query
ALTER TABLE Test ADD COLUMN houseno Number,age Number ,Ph no Number,Fax Number;
but i m getting an error that Syntax is not correct....
Where as if i run this query for only one field it is working fine....
i.e ALTER TABLE Test ADD COLUMN houseno Number;
For this scenario it is working but not working when we have to alter multiple fields
can any 1 suggest me wats wrong in the query.....
Please help ASAP
Ankush
Can any one help me
I am working in ms Access2000
In access I have made some tables now i want to alter one table
This table is having multiple fields now i want to write a query through which all the fields(columns) gets altered
e.g
I have a table say Test with fields houseno ,age
Now i want to add some new fields Ph no and Fax
For this thing i wrote a query
ALTER TABLE Test ADD COLUMN houseno Number,age Number ,Ph no Number,Fax Number;
but i m getting an error that Syntax is not correct....
Where as if i run this query for only one field it is working fine....
i.e ALTER TABLE Test ADD COLUMN houseno Number;
For this scenario it is working but not working when we have to alter multiple fields
can any 1 suggest me wats wrong in the query.....
Please help ASAP
Ankush