Decimal Places when exporting to txt

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

 

[Ken Snell]

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.

 

[Ian]

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>

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.

.

 

[Ken Snell]

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>

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>

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.

.