How do I Export Text field right justified and zero filed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am generating a 1098-T text file for IRS. The file is a TEXT format but
some of the fields contain numeric data one is 12 digits right justified and
zero filled. The Export function in Access wants to left justify and blank
fill.
 
Hi Robert,

Use a calculated field like this:
fField: Format([Field],"000000000000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I keep leading zeros and remove the decimal point when expo 2
Exporting numeric fields with leading zeroes 2
help with formatting and exporting data 1
Export Results of Access 2000 query to text file. 2
Exporting to ascii file 4
right justify number field in export 1
Right Justifying negative numbers 1
Exporting data to a fixed width text file 1

Back
Top