On Wed, 15 Aug 2007 13:34:01 -0700, wazabbbi wrote:

I created a table with two fields named "projectestimate" and "inspectionfee".

The inspection fee is 5% of the project estimate. I want the "inspectionfee"
field to automically calculate the amount.

How do I do that?

In a table? You don't.
Access tables are for storing data, not for data manipulation or
display.

If you store the [ProjectEstimate] and [InspectionRate] it's easy
enough to calculate the actual fee in a Query:
InspectionFee:[ProjectEstimate] * [InspectionRate]

Or you can do the calculation directly on a form or report, using an
unbound text control:
= [ProjectEstimate] * [InspectionRate]

Either way, the resulting value should not be saved in any table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail