Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can TRANSFORM be made to right justify an amout
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Can TRANSFORM be made to right justify an amout
Divers
Thread ID:
00811334
Message ID:
00811334
Vues:
43
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform