If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
save calculate value
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 |
#2
|
|||
|
|||
save calculate value
hi Zina,
Zina wrote: 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 -- |
#3
|
|||
|
|||
save calculate value
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 "Zina" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|