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

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.
 
J

John Nurick

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

Export Results of Access 2000 query to text file. 2
How do I keep leading zeros and remove the decimal point when expo 2
Help on zero field 1
Exporting numeric fields with leading zeroes 2
Fixed Format Text Export 2
right justify number field in export 1
Right Justifying negative numbers 1
How do I autofill spaces in right justified fields? 1

Top