OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

calculation in fields

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
danacol
General User
General User


Joined: 25 Apr 2009
Posts: 28

PostPosted: Wed Feb 10, 2010 12:02 pm    Post subject: calculation in fields Reply with quote

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
View user's profile Send private message
MSPhobe
Super User
Super User


Joined: 29 Sep 2005
Posts: 529
Location: England

PostPosted: Thu Feb 11, 2010 12:33 am    Post subject: Reply with quote

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
View user's profile Send private message
danacol
General User
General User


Joined: 25 Apr 2009
Posts: 28

PostPosted: Thu Feb 18, 2010 2:56 am    Post subject: Reply with quote

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
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10065
Location: Germany

PostPosted: Thu Feb 18, 2010 4:12 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group