Re: export numeric field right alligned

<janssensglb@xxxxxxxxx> schreef in bericht news:1188482898.568546.284170@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I want to export from Access 2000 a numeric field (double) to a text
file. The export file should be fixed length (no delimiters), the
field should have 9 digits in total, including 2 decimals. I want the
field to be right aligned so that the decimal separator is always in
the same column in the text file. I don't want to fill any leading
blanks with zeros.
I tried to do this using the format function in a query but I always
end up with a left aligned table...
Can anyone help me?
Thanks

Don't fill the leading blanks with zero's but with spaces...

Arno R
.

Quantcast