Hi Jason,
Your question is a little unclear.
You can use the expression you gave just as is for a REPLACE:
REPLACE ExtPrice WITH unitprice*unitquant*(1-discount)/100)*100
I'm assuming the actual field names, here.
Mark
>Hello -
>
>I am designing my ORDERS table in my app and need to build an expression to add/multiply my fields to return a final payment price.
>
>My table name is: ORDERS DETAIL
>My field is EXTENDED PRICE:
>
>The field extended price will hold the exrpession.
>
>I want to build an expression for the following scenario>
>
>unitprice*unitquantity*(1-discount)/100)*100
>
>What is the proper syntax for this expression in order for FoxPro to understand?
>
>Thanks for any assistance
>
>Jason
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.