exporting a text file from a query

G

Guest

I am using Access 2000. I have a number of numeric fields in my table that
are set to double, fixed, with 5 decimals. My query fields are also set to
fixed with 5 decimals. I am exporting the data from the query to a text file
using a specification that I set up as a width of 9, with 5 decimals. If the
data exported is .001 or less the data is displayed scientifically. I need
the text file to display at least 3 decimals so that it can be downloaded
into another database. Any suggestions?
 
W

Wolfgang Kais

Hello "Credit Lady".

Credit Lady said:
I am using Access 2000. I have a number of numeric fields in my
table that are set to double, fixed, with 5 decimals. My query fields
are also set to fixed with 5 decimals. I am exporting the data from
the query to a text file using a specification that I set up as a width
of 9, with 5 decimals.

How did you specify "5 decimals" in the specification?
If the data exported is .001 or less the data is displayed
scientifically. I need the text file to display at least 3 decimals so
that it can be downloaded into another database. Any suggestions?

Create an export query that calculates the desired numbers as text
using the Format$ function. For example:
Field1: Format$(tblTable.MyField, "0.00000")
 
G

Guest

You were right, I did not specify decimals within the specification.
Using the Format$ function worked great. Thank you for your time and
knowledge!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top