Need to multiply Quantity by Cost and Retail Cost

G

Guest

Need to multiply the quantity times the input cost and retail on a form is
this possible. So the table can reflect the quantity recieved, total cost of
the item and total retail of the item....

I have tried several combinations to no avail. It would be like extending
the price on an invoice or order.

if I take the quantity field times the price field it does not work. I know
this can not be hard I just can't seem to find the correct expression
 
G

Guest

add a control field (TOTALCOST) to your form in an event function set,
on exit or after update of the Quantity field

TOTALCOST = Quantity X InputCost

You may also need to set this in the on open or on load event of the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top