How to add a column in MS Access using SQL?

Question

Everytime I try to add a column using ALTER and ADD COLUMN I am getting a syntax error.

ALTER TABLE EMP_1

ADD COLUMN EMP_PCT NUMBER(4,2),

ADD COLUMN PROJ_NUM CHAR(3);

learn.microsoft.com/en-us/office/client-developer/access/… — Jason Li
– Jason Li, Commented May 7, 2019 at 2:45

Gordon Linoff · Accepted Answer · 2019-05-07 02:44:31Z

1

I am not familiar with a number data type. Perhaps you mean decimal:

ALTER TABLE EMP_1 ADD COLUMN EMP_PCT DECIMAL(5, 2);

You may also need two ALTER TABLE statements. I am just not sure if MS Access allows two changes in one statement.

answered May 7, 2019 at 2:44

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rd_nielsen · Accepted Answer · 2019-05-07 02:45:06Z

0

For a numeric type you should use NUMERIC, not NUMBER, and for a text type you should use VARCHAR.

answered May 7, 2019 at 2:45

rd_nielsen

2,4592 gold badges14 silver badges19 bronze badges