Kelly,
You can't create a calculated field in a table, this idea is
incompatible with the concept and purpose of a table.
You can create a calculated field in a query, and a calculated control
on a form or report. If the tables that contain the data you want to
use in your calculation are related, you can use a query that includes
both tables, or a form or report which is based on a query that includes
both tables, suitably joined. If they are not related, then you will
probably need to use a domain aggregate function.
