Re: syntax to add decimal column to access table using SQL?

From: "Lee-Anne Waters via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
Date: Fri, 24 Jun 2005 00:50:59 GMT

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

--
Message posted via http://www.accessmonster.com
.

References:
- syntax to add decimal column to access table using SQL?
  - From: cjf@stlouis

Prev by Date: Formula Help
Next by Date: Re: Error Message when running macro
Previous by thread: syntax to add decimal column to access table using SQL?
Next by thread: Re: syntax to add decimal column to access table using SQL?
Index(es):
- Date
- Thread

Relevant Pages

Re: float storage
... To increase the scale one must decrease the precision. ... SQL> create table numberz, ...
(comp.databases.oracle.misc)
Re: NUMBER(p) vs. INTEGER data type and CHAR(x) vs. VARCHAR2(x) in Oracle 10g and 9i - advantage
... scale) gives you an integer, constrained by a max of p digits. ... since 38 is the max precision? ... CHAR data type? ... There are numbers in the Oracle DB, the definitions of the others are types ...
(comp.databases.oracle.server)
Re: Trouble passing a numeric data type
... I did try using adDecimal but maybe it's the precision and scale ... >> numeric data type to my stored procedure, ...
(microsoft.public.vb.database.ado)
Re: Decimal Data Type, is rounding....ah!
... > I am submitting the following number to my SQL table to a field with a ... > Should I be using a different data type? ... Scale = number of decimal places to the right of the decimal, ...
(microsoft.public.sqlserver.programming)
Re: very new to sql
... For some reason when the value gets stored into the SQL ... The data type is saved as decimal. ... > Precision specifies the total number of digits both on the left and right ... > the result will be truncated at the defined scale... ...
(microsoft.public.sqlserver.msde)