I want to export a text file (Access2003) and have the numerics r.

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

Guest

I want to export a text file (Access2003) and have the numerics right
justify, so they can be used in another application. The numeric fields are
fixed format, two decimal places. The table itself is properly formatted.
Thanks!
 
Assuming you want the field to be, say, ten characters wide, you can use
something like the following:

Right$(Space$(10) & format([MyNumber], "#.00"),10)

Set that up as a calculated field in a query, and export the query, rather
than the table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"DNW-HAPLESS-MAINFRAME-USER"
 
Thank you Mr. Steele, I didn't know you could export from a query. Worked
first (actually second) shot.

Douglas J. Steele said:
Assuming you want the field to be, say, ten characters wide, you can use
something like the following:

Right$(Space$(10) & format([MyNumber], "#.00"),10)

Set that up as a calculated field in a query, and export the query, rather
than the table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"DNW-HAPLESS-MAINFRAME-USER"
I want to export a text file (Access2003) and have the numerics right
justify, so they can be used in another application. The numeric fields are
fixed format, two decimal places. The table itself is properly formatted.
Thanks!
Click to expand...
Click to expand...
 
Back
Top