Question updation of data

[sharinkm]

HI

i have a table which contais 3 fields a,b and c.Now i have form where i have given expressions a+b=c.i am getting the results on the form.But i am not able to get the result updated in my table.


please help mee......soom

 

[gemma-the-husky]

you shouild not need to store the result in the table. just do the sum whenever you need it.

you COULD store the result, but the problem is that if either a,b, or c change, and your code does not update the total for some reason, you end up getting an inconsistent database. that is why we generally recommend not to store totals.

 

[sharinkm]

but it is necessary to store that in the table and generate the report.but only in the form it is appearing.i need to store in the table to take report.please help

its a salary table

i have basic ,hra,ta,da,gross salary fields

i need to add thebasic+hra+ta=gross salary

i have given the expressions in gross salary record source

and i get the automated answer in the gross salary of the form

but coming back to the table only the gross salary field is not updated


please help me .

 

[Alansidman]

You should not be saving calculated fields in tables. Calculations may be made in forms, queries and reports. They can be determined as needed for any of these means to view them. Please read what Allen Browne has to say about storing calculations in tables.

http://allenbrowne.com/casu-14.html

 

[Alansidman]

Create the expression (calculation) in a query and make that query your record source for your report.