EXPORT TEXT FIXED LENGTH FILE FROM QUERY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

having a problem with some fields placing decimals in the output. they do not
show up in the query or any screen during the export just when the file is
created. I have tried setting the fields up as text, number with format of
integer, double, long integer...
what I have is a field that can be blank to 99 and I want to output it as
like '5 ' but it comes out as '5.' I'am exporting the query and using the
advanced button to specify the field positions in the output file.

any help but appreciated.

Roger
windows XP sp2, access 2003 with lasted jet database for 4.0
 
Roger said:
having a problem with some fields placing decimals in the output. they do not
show up in the query or any screen during the export just when the file is
created. I have tried setting the fields up as text, number with format of
integer, double, long integer...
what I have is a field that can be blank to 99 and I want to output it as
like '5 ' but it comes out as '5.' I'am exporting the query and using the
advanced button to specify the field positions in the output file.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I find that I have to use the Format() function to get rid of any
extraneous characters when exporting queries. E.g.:

SELECT product_id, Format(price,"#") As thisPrice
FROM ...

This will turn a price of 2.05 into 2, without the decimal point.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ/zpSoechKqOuFEgEQI9EgCffFFwK48s9KzPAi1qPlesUgjoS+YAoPEv
hz9ISojuasNwXgpvwUWNGHFk
=+E84
-----END PGP SIGNATURE-----
 
Back
Top