Need to multiply Quantity by Cost and Retail Cost

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jriehl - 20 Mar 2007 01:17 GMT

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

Reply to this Message

Hansford cornett - 20 Mar 2007 13:48 GMT

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.

Signature

Hansford D. Cornett

> 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
[quoted text clipped - 5 lines]
> 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

Reply to this Message