Number::

[new-agent]

Hi all

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


new for access
thx...

 

[R. Hicks]

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

RD

 

[John Vinson]

Hi all

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

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).

 

[new-agent]

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



------------------------------------------------