Decimal precision limited to only 2 places?

[Bigfoot]

My table has numeric field, defined as double, fixed decimal, 4 positions.
When I export it truncates to 2 decimal precision. How can I get around this?

 

[Ken Snell [MVP]]

Are you exporting to a delimited text file (say, a .csv file)? If yes,
unless you define an export specification for it, or use the Format function
to specify the number of decimal places for a calculated field in a query
(takes the place of the original field), ACCESS defaults to 2 decimal
places.

What are you wanting to do?

 

[Bigfoot]

Hi, Ken.

I am exporting to a .txt file, fixed-format (not delimited). I am using the
export specification. I do not see anyplace in the export spec window to
define the decimal precision, only the length.

 

[Bigfoot]

I am loading the data into our HP3000 mini computer (Image database). The
import accepts a decimal point anywear within the 12 byte field.

 

[Ken Snell [MVP]]

Then use a query as the source for the export, and in the query, use a
calculated field (following example will export with five decimal places):

MyOutput: Format([MyField], "0.00000")

 

[Bigfoot]

Ken, I tried exporting the query with your formula and got the same results.
Any other ideas?

Then use a query as the source for the export, and in the query, use a
calculated field (following example will export with five decimal places):

MyOutput: Format([MyField], "0.00000")
--

Ken Snell
<MS ACCESS MVP>

I am loading the data into our HP3000 mini computer (Image database). The
import accepts a decimal point anywear within the 12 byte field.

 

[Ken Snell [MVP]]

Post the SQL statement of the query that you are using.

--

Ken Snell
<MS ACCESS MVP>

Ken, I tried exporting the query with your formula and got the same
results.
Any other ideas?

Then use a query as the source for the export, and in the query, use a
calculated field (following example will export with five decimal
places):

MyOutput: Format([MyField], "0.00000")
--

Ken Snell
<MS ACCESS MVP>

I am loading the data into our HP3000 mini computer (Image database).
The
import accepts a decimal point anywear within the 12 byte field.

:

Are you exporting to a delimited text file (say, a .csv file)? If yes,
unless you define an export specification for it, or use the Format
function
to specify the number of decimal places for a calculated field in a
query
(takes the place of the original field), ACCESS defaults to 2 decimal
places.

What are you wanting to do?

--

Ken Snell
<MS ACCESS MVP>

My table has numeric field, defined as double, fixed decimal, 4
positions.
When I export it truncates to 2 decimal precision. How can I get
around
this?