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::')It's a presentation layer issue...
But you could look up CONVERT
What do you want it to look like?|||I looking for it to be formatted thusly...
$999,999.00
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment