Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    5

    Unanswered: Displaying results as currency

    I'm looking to display the results of the following query as currency. Any help with this would be greatly appreciated...

    SELECT SUM (sysTotalCharge) - SUM (sysTotalCredit) AS TotalNet FROM Bookings WHERE (sysRecordDate BETWEEN '01/01/::Year::' AND '01/31/::Year::')

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's a presentation layer issue...

    But you could look up CONVERT

    What do you want it to look like?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2004
    Posts
    5
    I looking for it to be formatted thusly...

    $999,999.00

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •