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
|
|||
|
|||
Getting a calculation in a form to update a table
Hi I have recently set up a new database but what I need it to do is a simple
calculation in a form, that will automatically update a table but when i set it up, the form carried out the calculation fine, but it did not enter the outcome of the calculation in the table. I am clearly doing somehting wrong i just can't figure out what it is. The table is call Table 1 and the formula for the calculation is =[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad difference] on the form, but not in the field in the table. Please Help Wez |
#2
|
|||
|
|||
Getting a calculation in a form to update a table
Calculating the answer when you need it is the best possible solution.
If you need to see it elsewhere than in your form, create a query, and type the expression into the Field row. Then use this query whereever you would have used your table. The reason this is better is that it cannot go wrong. If you store the value in the table, and then it doesn't match, you're shot. More information: Calculated fields at: http://allenbrowne.com/casu-14.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Wes" wrote in message ... Hi I have recently set up a new database but what I need it to do is a simple calculation in a form, that will automatically update a table but when i set it up, the form carried out the calculation fine, but it did not enter the outcome of the calculation in the table. I am clearly doing somehting wrong i just can't figure out what it is. The table is call Table 1 and the formula for the calculation is =[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad difference] on the form, but not in the field in the table. Please Help Wez |
#3
|
|||
|
|||
Getting a calculation in a form to update a table
On Thu, 6 Nov 2008 04:43:01 -0800, Wes
wrote: That's good, because in the vast majority of cases calculated fields don't belong in a table. Why? Because they can become out of sync, and it is very easy to recalculate in a query: select [Pad size Rim] - [Pad size Axle] as "pad difference" from Table1 So please delete that field from your table definition and use a query to calculate. -Tom. Microsoft Access MVP Hi I have recently set up a new database but what I need it to do is a simple calculation in a form, that will automatically update a table but when i set it up, the form carried out the calculation fine, but it did not enter the outcome of the calculation in the table. I am clearly doing somehting wrong i just can't figure out what it is. The table is call Table 1 and the formula for the calculation is =[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad difference] on the form, but not in the field in the table. Please Help Wez |
#4
|
|||
|
|||
Getting a calculation in a form to update a table
Hi Wes,
The guys are correct, the total should not be stored in the table. However, to add to thier response, if you plan to create a report with these fields you can also do the calculation there as well. So if no report you have the query and if you have a report do it in the report. Good Luck! "Wes" wrote: Hi I have recently set up a new database but what I need it to do is a simple calculation in a form, that will automatically update a table but when i set it up, the form carried out the calculation fine, but it did not enter the outcome of the calculation in the table. I am clearly doing somehting wrong i just can't figure out what it is. The table is call Table 1 and the formula for the calculation is =[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad difference] on the form, but not in the field in the table. Please Help Wez |
Thread Tools | |
Display Modes | |
|
|