R
R Ormerod
I am trying to export a table into a text file (.txt) in which the data has
to be formatted correctly in order for it to load into another system.
There are some numbers which need to be zero decimal places. These numbers
were 0 d.p. when imported into Access (from Excel) and are 0 d.p. in the
Access table.
When I export the table all number fields become 2d.p. I tried setting the
relevant fields' properties to 0 Decimal Places but this had no effect.
Note that all numbers are Double field size by default.
Any ideas?
to be formatted correctly in order for it to load into another system.
There are some numbers which need to be zero decimal places. These numbers
were 0 d.p. when imported into Access (from Excel) and are 0 d.p. in the
Access table.
When I export the table all number fields become 2d.p. I tried setting the
relevant fields' properties to 0 Decimal Places but this had no effect.
Note that all numbers are Double field size by default.
Any ideas?