Form Calculations

[kanjeep]

i'm new to Access and am streamlining some old logic for my comany that used to be done entirely in Excel spreadsheets.

I have added a calculation to my form and it shows up fine there. However, the total value is not passed to the table. Why is this? Do I need to create a special query in order for the value to show up in the table?

 

[rainman89]

Its not a good idea to store calculations in a table, just run the calculation when u need it

 

[Dreamweaver]

If you have used the control source like = [Field1]+[Field2] this will display the results in the field only same for a Query Calc: [Field1]+[Field2] displays the results ONLY
If you did this on a form YourFormField = [Field1]+[Field2] and YourFormField had a control source that related to a field in your table then the result would be added to your table. BUT!!!!

you shouldn't add the results of a calc to a table but do the calcs on the fly as was happening.

mick

 

[kanjeep]

Ok....Like i said, it shows up fine in my form and the adjoining report but I was just curious why it didn't update the table.

Thanks for the info.

 

[rainman89]

was the txtbox bound to the field in the table?