Database Query

[aburrow]

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

[qubit1]

Hi @aburrow,

Do you think that there’s something wrong with what SUM() is returning to you?

Please try installing the latest release of LO and see if that shows the same problem.