Hello I'm having some problems creating a query in DesigView mode. I'm trying to calculate a field with an Alias.
So I have a field in which I have MonthlyGrossWage, that field is numeric, has no decimals (for simplicity), only 5 digits, and its format is currency $ In my table, I have a the name of my employees, name, lastname, etc... and also this field MonthlyGrossWage... so I enter John.... Doe... 1150$... Okay that is fine. I have my table with all my employees names, lastnames... and also the salary they get monthly at monthlygrosswage Okay... How much cost me the employee per hour? Assuming we have a labour day of 8 hours, I'd divide the monthlygrosswage by 8 So the calculation it's quite simple. "MonthlyGrossWage" / 8 ... in query designview I add also an alias, so I can output the result of the calculation in a field... let's say my Alias is HourlyGrossWage So... my query design view looks like this: "MonthlyGrossWage" / 8 HourlyGrossWage Perfect. What happend now is I display the proper calculation in the field HourlyGrossWage... but! I don't see the result in dollars !!! and of course I'd like to see it in dollars... so I get the calculation but I cannot setup the format of the output field... How may I do this? Cheers -- View this message in context: http://nabble.documentfoundation.org/Calcultated-fields-in-query-how-to-output-in-currency-format-tp4144868.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