Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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

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


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:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.