Alter Table Add Column

Hi:
I have an Access Query that adds a new column to an existing table.  My code is:

ALTER TABLE abc ADD COLUMN salary number;

However, I also wanted to include the following format for the datatype "number":

FieldSize = Decimal
Format = Fixed
Precision = 13
Scale = 2
Decimal Places = 2

Is there a way to include these specifications in the query?  I know I can change the settings manually in the Access table afterwards but since the query is run inside a VBA (stand alone project), no user override is alowed.
AugustineWanAsked:
Who is Participating?
 
SethiConnect With a Mentor Commented:
Use square brackets:
ALTER TABLE abc ADD COLUMN salary number[15, 2];
0
 
william_jwdCommented:
try,

ALTER TABLE abc ADD COLUMN salary number(15, 2);
0
 
AugustineWanAuthor Commented:
I tried:

ALTER TABLE abc ADD COLUMN salary number(15, 2); and
ALTER TABLE abc ADD COLUMN salary number(15. 2);

Both gave me "Syntax Error".
0
 
SethiCommented:
I answered the question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.