Can I create a field in a table containing a formula?

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

Guest

I have two numeric fields and would like to create a field in the table that
will calculate a value based on the two fields. Is this possible to do
within the table, and if so how?
 
ktlooney said:
I have two numeric fields and would like to create a field in the
table that will calculate a value based on the two fields. Is this
possible to do within the table, and if so how?

No, you do this in a query and then use the query every place where you need
that value instead of using the table.

Spreadsheets intermix hard data and calculations within the same grid. Database
tables do NOT.
 
Back
Top