updation of data

[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 .

 

[Pat Hartman]

Calculated fields are not generally stored especially when all the operands exist in the same record. Move the calculation to a query so you can use that query in multiple places and not have to recreate the calculation for each form/report.