Ask Your Question

equations in query or form

asked 2016-03-18 17:04:57 +0100

bdphifer gravatar image

Want to show a result of the multiplication of two fields in a form. It is a number and a percentage. I am ok with either doing it in the query that gets the data or the form itself (subform in table layout).

Is there a way to easily do this?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-18 19:52:40 +0100

Ratslinger gravatar image

updated 2016-03-18 20:00:09 +0100


There are a few ways to accomplish this without coding. A brief discussion can be seen in a previously asked question Here . Based upon that, an enhancement was requested Seen here but I don't think it ever was included in LO.

That being said your solution may be relatively easy. I've created a sample SQLselect.odb which already has some data entered. Note that when entering a new record, the calculated amount is not available until the record is saved. Once saved, you can go back to the record and the calculated amount is displayed. Also any direct entry into the calculated field is meaningless.

The main elements here are the properties of 'MainForm' in the Data tab (Content type and Content).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-18 17:04:57 +0100

Seen: 51 times

Last updated: Mar 18 '16