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