Hi Gert,
I put up a working example of doing this on the Base form at OOOforums.
http://www.oooforum.org/forum/viewtopic.phtml?t=23217&highlight=calculated+field
Take a look and see if it helps.
Andrew Jensen
Tom Schindl wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Gert,
Assume I have two table fields Qty and CostPrice. How can I create a form
field that displays the result of Qty * CostPrice?
You cannot do this in a form, but in a query. Create a query which
contains all fields of interest, plus "Qty * CostPrice", and base your
form on this query.
Ciao
Frank
Well but that wouldn't be updated until you save the form. Better way
would maybe be writing a Macro which listens on the focus events of the
2 fields and updates the 3rd one?
Tom
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Using GnuPG with Mandriva - http://enigmail.mozdev.org
iD8DBQFDO+IRkVPeOFLgZFIRAq4AAJ422ym59RhCpOryEKzdmJMepjUVrQCfe16U
bsZ8q6sYBgNJgamYF5S/rYg=
=7qaf
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
|
