Re: Calculation in new form field (Newbie question)

Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]> 
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

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.