none
Format SQL field totals

    Question

  • I have a query that does the following:

    Select acct_tran, count(acct_nbr)  From transactiontbl   Group By acct_tran  Order By count(acct_nbr) desc

    Result shows  Tran      HowMany

                         XYZ        2490287

    How can I get it to display as

                         XYZ       2,490,287

    Thanks in advance.

    danc09


    Dan

    Wednesday, June 25, 2014 8:44 PM

Answers