save calculate value

[Zina]

I have design a form that enter information of some goods , I enter Price per
unit of item and quantity of item ,then I calculate the total price of that
item ,I want to save the new calculated value in field I mean I want to save
vallue in the related field of its related table

Thanks in advance

 

[Stefan Hoffmann]

hi Zina,

I have design a form that enter information of some goods , I enter Price per
unit of item and quantity of item ,then I calculate the total price of that
item ,I want to save the new calculated value in field I mean I want to save
vallue in the related field of its related table

Why would you do that? In a database you normally never save/store
calculated values.

To (re-)use calculated values create a query based on that table:

SELECT *, Price*Quantity As TotalPrice
FROM yourTableName

This is the queries SQL.

Just use this query as record source for your forms and your done.



mfG
--> stefan <--

 

[GBA]

presuming your underlying table has a 'Total' field; and that this field also
exists on your design form; then
in the 'AfterUpdate' event of the quantity field put:
me.Total=me.price*me.quantity

that will simply automate that math for your user