Modify table to include calculated values

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.

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!

--
Good luck

Jeff Boyce
Access MVP

Okay, let's try this. The subform displays is spreadsheet
view, with the first column being year. Would a pop-up
modal form work, with the four components entered and then
the sum of the four being saved in the subform. Clear as
mud? If that would work, how would I keep loosing the
values already in the underlying table?
-----Original Message-----
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.
.

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?

--
More info, please ...

Jeff Boyce
Access MVP

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?

--
More info, please ...

Jeff Boyce
Access MVP

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?

--
More info, please ...

Jeff Boyce
Access MVP