Software

Ask something
Discussion Locked

Access:zeroes disappear in text transfer

0 helpful
3 replies

by rboyer 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a table that I export to a text file. I use a fixed width specification. I have several fields that are number fields. When they are transfered if it is a whole number then it drops the .00. Does anyone know how to correct this?

3 replies

by badermsb

Ok, first things first. There are different types of number fields in Access. The default is usually a long integer. If you want to maintain decimals in your export first make sure the number type is single, double or currency. The next step is to change the decimal from auto to 2. If you do this it will export the way you want.

This discussion is closed to new replies.