Decimal precision limited to only 2 places?

B

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?
 
K

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?
 
B

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

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

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")
 
B

Bigfoot

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

Ken Snell said:
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>

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

Ken Snell [MVP]

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

--

Ken Snell
<MS ACCESS MVP>

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

Ken Snell said:
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>

Bigfoot said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top