Right Justifying negative numbers

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

 

[John Nurick]

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.