Number::

  • Thread starter Thread starter new-agent
  • Start date Start date
N

new-agent

Hi all

How to use datatype number in MSAccess table
like dbf such as n(numeric,decimal)


new for access
thx...
 
Use Number datatype .. and Field Size either Single or Double dependin
on the values inserted.

RD
 
Hi all

How to use datatype number in MSAccess table
like dbf such as n(numeric,decimal)
Click to expand...

There are several subtypes of the Number datatype: Integer, Long
Integer, Float, Double. The Decimal datatype is available if you
create a table in code, but not through the user interface.

If your numbers have decimal places use Float (about 7 decimal places
precision) or Double (14 decimal places); or use a Currency datatype
instead of any of the Number types - this gives you exactly four
decimals and no roundoff error, and a range into the trillions. If
your numbers do not have decimal places use Integer (range to 65535)
or Long Integer (range to two billion odd).
 
I want to export my table to dbf file format,
but i can't fix fieldwidth for datatype number;
like this
mdb/ number as double, decimal 2
..dbf (i want)/ number 12 decimal 2

when i export table to .dbf
fieldwidth =50 decimal 2 why? and How to...

or I must to do another way

-----Original Message-----
Use Number datatype .. and Field Size either Single or Double depending
on the values inserted.

RDH



------------------------------------------------
Click to expand...
 
Back
Top