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

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

 

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

 

[DNW-HAPLESS-MAINFRAME-USER]

Thank you Mr. Steele, I didn't know you could export from a query. Worked
first (actually second) shot.

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!