To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67726
Issue #|67726
Summary|calculated fileds outcomes not usable inside the same
|query
Component|Database access
Version|OOo 2.0.3
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|fornarif
------- Additional comments from [EMAIL PROTECTED] Mon Jul 24 08:41:26 -0700
2006 -------
Hello,
this is not a bug report, but a request for a useful feature that Base doesn't
support yet.
Let's say I need to calculate a price markup based on some percentage rate. I
can build a query with two starting fields: "NetPrice" and "MkUpRate". Then, I
can create a third field inserting a simple formula:
"NetPrice" * "MkUpRate" / 100 AS "MarkUp"
Usually, users need also the sum of "NetPrice" and "MarkUp", and here there are
two ways to do it at present, with Base:
1) creating a fourth field with the following formula:
"NetPrice" + ("NetPrice" * "MkUpRate" / 100) AS "MarkUp" AS "Total"
but it's not a good (and safe) solution to repeat the same formula more than
once, mainly when it is more complicated.
2) creating a II level query (query in query) where it'll be possible to execute
the sum "NetPrice" + "MarkUp", avoiding repetitions of any formulas. But, this
way, we'd need two queries rather than one.
IMO, the best solution seems to be that one Access offers to its users: when
using calculated fields inside queries, users must declare them as "Expression",
by the same item available in the List Box on "Function" row. This way, Access
can recognize calculated fields and properly use their results.
I think this feature could help Base users to simplify a lot their projects,
avoiding many repetitions of their formulas.
Best regards and thanks in advance,
Franco
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
