Formula result into the table

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

Guest

I am creating a new database where I need a calculation of two numbers to be a value in the table (similar to excel formula). A

dditionally, I need that value to be used in an average calculation that is also a value in the table. It is my understanding that calculations can only be done on the form or report but they are never a part of the table.

Is there a way to get around this.....using queries possibly?

Thank you in advance,

Tara
 
You can do calculations in queries, forms, and reports. You can not do
calculations in tables. Also, it is not recommended to store the calculation
results in the table. Just do the calculation whenever you need the value.

There are times it is definitely better to do the calculation in a query
than in a form or report. One advantage is that it creates a new field that
you can now Sum, Avg, etc in the form or report.

--
Wayne Morgan
Microsoft Access MVP


Tara said:
I am creating a new database where I need a calculation of two numbers to
Click to expand...
be a value in the table (similar to excel formula). A
dditionally, I need that value to be used in an average calculation that
Click to expand...
is also a value in the table. It is my understanding that calculations can
only be done on the form or report but they are never a part of the table.
 
Back
Top