First time here? Check out the FAQ!
asked 2012-07-12 13:40:05 +0200aburrow
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-12 13:40:05 +0200
Seen: 103 times
Last updated: Mar 06