Right Justifying negative numbers

  • Thread starter Thread starter kevin
  • Start date Start date
K

kevin

My goal is to export a fixed position flat file that
contains accounting data that will be imported into an
accounting system.

The problem is that after I run a make-table query to
right justify the amount fields, the negative sign is in
the left most position followed by zeros until the first
numeric is encountered (-000000000123.45). The desired
format is right-justified -123.45.

Are there any suggestions?
 
Hi Kevin,

Use a calculated field in the query that produces a field the right
width ready-padded with spaces. Something like

fXXX: Right(Space(NN) & Format([XXX], "0.00;-0.00"), NN)

where XXX is the name of the field and NN is the number of characters.
 
Back
Top