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

K

ktlooney

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?
 
R

Rick Brandt

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?
Click to expand...

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.
 

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

Split form 0
Finding the right style field in VBA 0
How to have two tables on same line? 1
Is this possible? 0
Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
MS Project. Real progress of the project, % complete 1
comparing table values 1

Top