Problem when exporting numbers in text

  • Thread starter Thread starter Stathisb
  • Start date Start date
S

Stathisb

Dear all,

when I want to export numerical data into a delimited text
file and my number is quit large (i.e 123456789.11) what I
get in the text file is the following (1.234568e+08). How
can I change so that in the text file to have the actual
number I wrote? If I have to change the Format of the
number field (Long integer, decimal or else) please let me
know.
Thanks a lot in advance
 
Create a query uses the Format function to format the numbers however you
want them to appear.

Export the query, not the table.
 
Create your query as usual (adding the table and dragging the fields to the
grid).

Where you have the particular field, change it (in the grid) from
MyFieldName to Format([MyFieldName], "###########.00") or whatever format
you want. Change MyFieldName as appropriate.
 
Thank you very much,
everything is working fine now.
Thanks a lot
-----Original Message-----
Create your query as usual (adding the table and dragging the fields to the
grid).

Where you have the particular field, change it (in the grid) from
MyFieldName to Format([MyFieldName], "###########.00") or whatever format
you want. Change MyFieldName as appropriate.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I am not very familiar with access. How the syntax should
be in the query?
let
me
Click to expand...


.
Click to expand...
 
Back
Top