[left][color=#003366]how to add a field to an existing table using sql statement in MS Access[/color][url=“http://sdfsd”]
[/left]
ALTER TABLE <<tablename>> ADD COLUMN <<newfieldname>> TEXT(25);
see
http://www.blueclaw-db.com/alter_table_ddl.htm
for more info.