export numeric field right alligned
- From: janssensglb@xxxxxxxxx
- Date: Thu, 30 Aug 2007 07:08:18 -0700
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
.
- Follow-Ups:
- Re: export numeric field right alligned
- From: Arno R
- Re: export numeric field right alligned
- Prev by Date: Re: A2K - how to select a record, programatically on a continuous subform
- Next by Date: Re: A2K - how to select a record, programatically on a continuous subform
- Previous by thread: Advice needed for a growing Access 2000 project
- Next by thread: Re: export numeric field right alligned
- Index(es):