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

  • Thread starter DNW-HAPLESS-MAINFRAME-USER
  • Start date
D

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!
 
D

Douglas J. Steele

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"
 
D

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