Decimal Places when exporting to txt

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

When I export a query to txt (Microsoft Word Merge)file I
lose decimal places. It is rounded to 2 decimals. I need
more decimal places. Is it possible to set the export to
more than 2 decimal places.
 
Easiest thing to do is to wrap the field that has the decimals in it with
the Format function to get the desired number of places:

MyField: Format([FieldName], "0.000000")

Above will give you six decimal places.
 
Thanks for the response but this did not work. The field
in access has enough decimal places but they are
truncated to 2 when exported to TXT. Any other ideas?
-----Original Message-----
Easiest thing to do is to wrap the field that has the decimals in it with
the Format function to get the desired number of places:

MyField: Format([FieldName], "0.000000")

Above will give you six decimal places.


--

Ken Snell
<MS ACCESS MVP>

Ian said:
When I export a query to txt (Microsoft Word Merge) file I
lose decimal places. It is rounded to 2 decimals. I need
more decimal places. Is it possible to set the export to
more than 2 decimal places.
Click to expand...


.
Click to expand...
 
No, change the query to have this done. In other words, replace the original
field in the query with a calculated field that uses the Format function.

--

Ken Snell
<MS ACCESS MVP>

Ian said:
Thanks for the response but this did not work. The field
in access has enough decimal places but they are
truncated to 2 when exported to TXT. Any other ideas?
-----Original Message-----
Easiest thing to do is to wrap the field that has the decimals in it with
the Format function to get the desired number of places:

MyField: Format([FieldName], "0.000000")

Above will give you six decimal places.


--

Ken Snell
<MS ACCESS MVP>

Ian said:
When I export a query to txt (Microsoft Word Merge) file I
lose decimal places. It is rounded to 2 decimals. I need
more decimal places. Is it possible to set the export to
more than 2 decimal places.
Click to expand...


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