Total In Textbox

[daneo2k3]

easy one

i have a table and need a total field adding before i create a form on it my table name is tblPurchaseorder and the two fields i want to calculate are called quantity and price what expression do i type and how do i get it to show the total in currency? cheers dane

 

[ColinEssex]

Do the total on the form in a TextBox not in a table. That way if anything changes, the total will always be right.


Col

 

[daneo2k3]

I have created the total in a text box in the form but how do i get it to calculate the quantity field x the price field in £??? cheers dane

 

[ColinEssex]

I have created the total in a text box in the form but how do i get it to calculate the quantity field x the price field in £??? cheers dane

[Price] * [quantity]

set the format option to currency.


Col