Re: Calculation in new form field (Newbie question)

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]
>
>
>
>  
>