Ask Your Question

Database Query [closed]

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

aburrow gravatar image

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

qubit gravatar image

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.


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 12:16:31.252267

1 answer

Sort by » oldest newest most voted

answered 2013-03-06 10:40:18 +0100

qubit gravatar image

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.

edit flag offensive delete link more

Question Tools


Asked: 2012-07-12 13:40:05 +0100

Seen: 368 times

Last updated: Mar 06 '13