Database Query

asked 2012-07-12 13:40:05 +0200

aburrow
1 ● 1

updated 2013-01-28 23:14:41 +0200

qubit
5693 ● 3 ● 48 ● 41

I'm trying to setup a query that displays MemberID and Total Payments in two columns.

That part I've done quite easily. What I need to do is display the Total Payments column in dollar format. The field is stored in the table as "Double", my SQL Statement currently is " SELECT "MemberID", SUM( "PaymentAmount" ) AS "Total Payments" FROM "Payments" GROUP BY "MemberID" ORDER BY "MemberID" ASC "

I've done some more testing. If I remove the "SUM" syntax and just show the "Payments" field it displays in currency format. It appears that something in the "SUM" command is stripping out the currency format.

Thanks