Hi All again,

my problem with Transfer text is that although in my query
the numeric values appear with correct number of decimal
digits, the resulting txt file has values such as 8.0e-03
instead of 0.008.

Any ideas anyone?

thanks
MariaH

Create a query that has a calculated field such as :
    OutMyField: Format([MyField], "#,##0.000")

Use the Query in Transfer Text, and the formatting will be exported.

--
Allen Browne - Microsoft MVP (Most Valuable Professional)
Perth, Western Australia.
Allen Browne's Database And Training.
Tips for MS Access users: http://users.bigpond.net.au/abrowne1
Reply to the newsgroup. (Email address has spurious "_SpamTrap")