Modify table to include calculated values

[Kevin]

I maintain a database to track tax abated properties. In
it there is a table (913EX) that tracks the year, gross
value, exempt value, tax district, taxes abated, and
contract compliance. Because of a change in Ohio law, I
now need to track the four components of the gross and
exempt values - furniture & fixtures, machinery &
equipment, manufacturing inventory, and merchandising
inventory. Because of the effective date of the law, I
won't need to track the values prior to July 1, 2004, only
after. The 913EX table is also a subform, in table format,
of a form that summarizes each agreement. (This agreements
form is in turn a subform of the main form that tracks the
companies.)
I noticed in the Northwind sample database there are
several calculated fields in the tables from subtables,
but I don't know how to go about creating them.
Thank you.

 

[Jeff Boyce]

Kevin

Tables hold data, forms display it. In Access, tables are not forms or
subforms.

As a general rule, storing calculated values in a table is not necessary,
nor even a good idea. In some cases, there is an underlying business need
to do so, but if you already have the "pieces" you'd use to calculate the
value, you can do that in a query, rather than doing it and storing it.

Besides, once you've stored a calculated value, any change to any of the
components requires you to recalculate and re-store it!

 

[Jeff Boyce]

Kevin

Yes, muddy.

I'm still not getting a clear picture of how your data is structured. It
may be that your data structure is constraining what you can do in your
forms.

Forget the forms for a moment, and tell us a bit more about the data
structure. What tables are you using and what data is in those?