Yes, I suspect this is impossible, we cannot have a "currency" variable, because we would have to have thousands of different variables according the thousands of currencies in the world. What BASE can do is to format the way the output is presented to the user, however, sadly I've discovered that even if you change the format of a query to show the results in euros, for example, sadly, LibreOffice Base don't remember the field format. I've documented this as a bug: https://bugs.documentfoundation.org/show_bug.cgi?id=90360 But, yes, since a SQL point of view, it's impossible to show the value with the currency format. You are right. Cheers
-- View this message in context: http://nabble.documentfoundation.org/Calcultated-fields-in-query-how-to-output-in-currency-format-tp4144868p4145004.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted