Use '@$ 999,999.99' instead of '@$B 999,999.99'.

'B' specifies "left justify'.

>Been trying to figure out how to make a "money" result in a select statement appear right justified.
>
>For example, using
>"SELECT COUNT(*), TRANSFORM((SUM(MTON(amount))*-1), '@$B 999,999.99') AS money, field2 FROM mydb GROUP BY field2" etc, forces a beautiful "LEFT" justified "$123,456.78" along with "$1.23", etc., as in
>"$123,456.78"
>"$1.23"
>but how do we make this right justify? as in
>  "$123,456.78"
>               "$1.23"
>
>That is the question. TIA. /psb