Right Align

  • Thread starter Thread starter Jessie
  • Start date Start date
J

Jessie

Hello.
I am having a huge problem exporting data right justified-

I have an income field that is 7 characters long. a
person's income here can range from 1 to 9999999 or it can
say None. I need to have the ending position in the fixed
width text file be the same regardles of character length.

Any Help will be hugely appreciated!

Thanks.
Jessie
 
Hi Jessie,

Create a query based on the table. In the query, use a calculated field
like this:
rIncome: Right(" " & [Income], 7)

That's 7 spaces, same as the width of the field you want. Then export
the query.

Any time you need leading zeros on a numeric field, use something like
rNumField: Format([NumField], "0000000")
 
Back
Top