Using a formula to fill a field

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

Guest

I am ery new to Access and was wondering, is there anyway to make a field
fill automaticaly with a formula? Like in excel for example if you have a
fromula on a cell and the arguments change the cell changes.
I have a table with a field of invoice amounts and then a table with account
info, i want to know if there is a way for the account table (ie: Balance
field) to update automaticaly when you add an invoice with that accountID.
 
Access is a relational database. An Access table may look like a
spreadsheet, but it is really just a "bucket o' data". No, you can't add
formulas into fields in an Access table.

In fact, it is only rarely necessary to store a calculated value at all.
More often, using a query to (re-)calculate the value is the way to go ...
it ensures that the latest data is used in the calculation.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top