| View previous topic :: View next topic |
| Author |
Message |
danacol General User

Joined: 25 Apr 2009 Posts: 28
|
Posted: Wed Feb 10, 2010 12:02 pm Post subject: calculation in fields |
|
|
Hello,
Wondering if is possible to apply calculation proprieties to form fields.
for example, having two fields, field A and field B, is it possible to get in a third field the A+B result?
thanks |
|
| Back to top |
|
 |
MSPhobe Super User

Joined: 29 Sep 2005 Posts: 529 Location: England
|
Posted: Thu Feb 11, 2010 12:33 am Post subject: |
|
|
First a thing that you may already know... but many people need to be told...
It is a bad idea to fill a field in a TABLE (using the term in the narrow, database, sense) with the result of the sort of calculation you are talking about.
However it is easy and common to display the result of such a calculation on a form.
See....
http://sheepdogguides.com/fdb/fdb1calcf1.htm
for How To. |
|
| Back to top |
|
 |
danacol General User

Joined: 25 Apr 2009 Posts: 28
|
Posted: Thu Feb 18, 2010 2:56 am Post subject: |
|
|
thanks for the link.
It shows how to get calculations with queries, but would it be possible also using macros?
PS why is a bad idea to fill in fields with calculations??
Thanks |
|
| Back to top |
|
 |
Villeroy Super User


Joined: 04 Oct 2004 Posts: 10065 Location: Germany
|
Posted: Thu Feb 18, 2010 4:12 am Post subject: |
|
|
| danacol wrote: | thanks for the link.
It shows how to get calculations with queries, but would it be possible also using macros?
PS why is a bad idea to fill in fields with calculations??
Thanks |
Because the stored calculation result remains the same when the underlying data have changed.
You can calculate the correct values from the actual data at any time. _________________ Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
 |
|