Using a formula to fill a field

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

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating a field with an aggregate query 1
I want access to fill a field with the current date 4
Combining duplicates into a single multi value field 8
Auto Populate a field 0
auto fill a field 3
Create a macro to change a value in a record 1
ranking records 10
Copy a result of calculated control to another field 5

Top