Problem when exporting numbers in text

[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

 

[Douglas J. Steele]

Create a query uses the Format function to format the numbers however you
want them to appear.

Export the query, not the table.

 

[Guest]

I am not very familiar with access. How the syntax should
be in the query?

 

[Douglas J. Steele]

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.

 

[stathisb]

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

.