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
|
|||
|
|||
Result not stored in the table
I modified the customer template database that available from Microsoft
Online as per my requirement. in the table case. I add new fields, 1st [Price / Qauntity], 2nd [Qauntity], 3rd [Total Price]. now in the case detail form I add those fields, but in the [Total Price] I made formula that will calculate [Price / Qauntity]*[Qauntity]. but I surprised there is no result in the case table Regards |
#2
|
|||
|
|||
Result not stored in the table
Jalal wrote:
I modified the customer template database that available from Microsoft Online as per my requirement. in the table case. I add new fields, 1st [Price / Qauntity], 2nd [Qauntity], 3rd [Total Price]. now in the case detail form I add those fields, but in the [Total Price] I made formula that will calculate [Price / Qauntity]*[Qauntity]. but I surprised there is no result in the case table Regards Surprised? The method for getting a control to store its value in a field is to place the name of the field in the control's ControlSource property. You have not done that. You have an expression in there. A control is either bound to a field OR contains an expression. It cannot do both. The good news is that proper database design dictates that you should not be storing that value in your table anyway. Just remove that field from your table and any place you need to see that value use the expression you are using now in your form. Tables should contain raw data only, not data that can be derived from other data. That is the job of queries, forms, and reports to calculate in real time as needed. That way there is never any doubt as to its correctness. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|