syntax to add decimal column to access table using SQL?

C

cjf@stlouis

I am trying to create access tables using SQL rather than access design view.
The syntax for doing this does not seem to follow MSSQL rules. Can you show
me how to add a numeric(10,3) column for example. Thanks, Chris
 
L

Lee-Anne Waters via AccessMonster.com

hi,

set the data type in SQL to numeric and the precision value to 10 and then
the scale value to 3

hope that helps
 
V

Van T. Dinh

****
CREATE TABLE tblTest
(
FldDefaultDecimal DECIMAL,
FldSpecificDecimal DECIMAL(10, 3)
)
****

Default is (28, 18)
 
Top