Altering a table with multiple fields (1 Viewer)

[ankush]

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

 

[MikeAngelastro]

A quick fix is to run the alter query once for each field you want to add. After this all the fields should be in the table.