Message
From
17/07/2003 20:23:35
To
17/07/2003 19:42:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00811334
Message ID:
00811342
Views:
16
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
'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