regarding expression builder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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]
 
Back
Top