Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Can TRANSFORM be made to right justify an amout
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement