syntax to add decimal column to access table using SQL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
****
CREATE TABLE tblTest
(
FldDefaultDecimal DECIMAL,
FldSpecificDecimal DECIMAL(10, 3)
)
****

Default is (28, 18)
 
Back
Top