export numeric field right alligned

[janssensglb]

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

[Arno R]

<ja*********@gmail.comschreef in bericht news:11**********************@g4g2000hsf.googlegro ups.com...

>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

[janssensglb]

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

Arno R

I'm not sure how I can do that.
If the value of the record is eg. 1.23, I need to fill 6 leading
blanks with spaces. If the value is 1234.56, I need to fill 3 leading
blanks with zeros.
Can I do this using the format function?
Thanks

[Salad]

ja*********@scarlet.be wrote:

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

Arno R

I'm not sure how I can do that.
If the value of the record is eg. 1.23, I need to fill 6 leading
blanks with spaces. If the value is 1234.56, I need to fill 3 leading
blanks with zeros.
Can I do this using the format function?
Thanks

a = 123.45
? Right(string(10," ") & a,10)
123.45
or
? Right(string(10,space(1)) & a,10)
123.45

[Salad]

Salad wrote:

ja*********@scarlet.be wrote:

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

Arno R

I'm not sure how I can do that.
If the value of the record is eg. 1.23, I need to fill 6 leading
blanks with spaces. If the value is 1234.56, I need to fill 3 leading
blanks with zeros.
Can I do this using the format function?
Thanks

a = 123.45
? Right(string(10," ") & a,10)
123.45
or
? Right(string(10,space(1)) & a,10)
123.45

Hmmmm...I decided to check for a number like 123.50.
a = 123.50
? Right(string(10,space(1)) & a,10)
123.5
? Right(string(10,space(1)) & format(a,"0.00"),10)
123.50
You might want to format to keep the ending 0's.