regarding expression builder

S

shabla

wat i want is to insert the calculated values(simple addition or subtraction)
in fields of my table by using expression builders in my forms..i have made
that feild in the table but still it doesnot store the paticular value in
that field..plz help me out..looking forward for ur replys..thanx
 
D

Douglas J Steele

It's generally considered a bad idea to store calculated values in the
table: it's almost always more efficient to recalculate the value, rather
than retrieve it from the hard drive, plus if you change any of the
underlying values, you must remember to perform a recalculation.
 
F

fredg

wat i want is to insert the calculated values(simple addition or subtraction)
in fields of my table by using expression builders in my forms..i have made
that feild in the table but still it doesnot store the paticular value in
that field..plz help me out..looking forward for ur replys..thanx
Click to expand...

Use Access properly!
The long and short of it is that you probably should NOT store the
calculation result in any table.
As long as your table stores the individual data that makes up the
calculation, whenever you need the result, re-calculate it, in a
query, on using an unbound control on a form, or in a report.
=[Field1] + [Field2]
 
Top