ALTER TABLE query: decimal places 1

[mekon]

hi all

I'm having problems with an ALTER TABLE query. I'm using the basic Access 2000/sql query window setup..

as well as dozens of text fields, I need to add a double integer column with a fixed number of decimal places.

(I can do this in the table design view of course, but am looking at ways to save time as hundreds of tables need modifying)

ALTER TABLE master
ADD COLUMN
av_price DOUBLE;

I can't seem to find the syntax to specify the number of decimal places in the above query. is this possible, or are my options limited by Access 2000?

many thanks in advance

M

 

[cmmrfrds]

If you want fixed decimal places don't use DOUBLE which is a floating point number and is always an approximate. Try using number(p,s). Where p = precision and s = number the number of places after the decimal.

ALTER TABLE master
ADD COLUMN
av_price NUMBER(12,2);

 

[mekon]

thanks for your response. I'm still getting a "Syntax error in ALTER TABLE statement" error message though

M

 

[cmmrfrds]

Try numeric instead of number.

ALTER TABLE master
ADD COLUMN
av_price Numeric(12,2);

 

[shannonp]

Hey Hi mekon

I was just wondering if you got that syntax error sorted?? As I too am having the same problem with decimals.