right align for some exported fields in txt format

[srijan]

hi
I would like to export the data where certain field like
amount field to be right align when exported.. since all
the export .txt fields are left align.

Thanks

 

[John Nurick]

Hi Srijan,

Create a query that uses calculated fields like this:
RFieldName: Right(" " & [FieldName], 5)

The idea is to pad the contents of the field with the same number of
spaces as you want the exported field to have characters, and then take
just that number of characters from the end of the result.

If you want leading zeros on numeric fields, use something like this:
NFieldName: Format([FieldName], "000000")

hi
I would like to export the data where certain field like
amount field to be right align when exported.. since all
the export .txt fields are left align.

Thanks

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.