Need to turn off rounding in Access 2007

[NicoleDBS]

I am exporting a table using a Specification, but everytime the [Amount]
field converts to the .txt file it rounds up. I need it stay in its literal
format. Does anyone know how to turn off the default rounding?

 

[David H]

CStr() will convert a value to a string.

 

[Graham Mandeno]

Hi Nicole

Do you mean it rounds to a whole number? If so, I suspect that field in
your specification is defined to be an integer data type (long or integer).

In any case, if you wish to export numeric data with, say, 4 decimal places,
you could use the Format function:
Format([FieldName], "0.0000")