D
Dave
I am trying to build a table of Inventory Items including
such things as Purchase Cost and various conversion
factors to allow a Unit Cost to be calculated. For
example, if I purchase an item for $120 per case with 10
items per case the Unit Cost would be $12.
I would like to store the Unit Cost in the Inventory
table. Access will not allow me to create a "calculated"
field in a table. I believe I could use an update query
to update a numeric field, but that query would need to be
run each time any item is updated. Controlling that would
probably be a nightmare.
I am not an Access expert, but is there a way that the
Unit Cost can be calculated and stored in the table when
an item is added or changed?
Thanks.
such things as Purchase Cost and various conversion
factors to allow a Unit Cost to be calculated. For
example, if I purchase an item for $120 per case with 10
items per case the Unit Cost would be $12.
I would like to store the Unit Cost in the Inventory
table. Access will not allow me to create a "calculated"
field in a table. I believe I could use an update query
to update a numeric field, but that query would need to be
run each time any item is updated. Controlling that would
probably be a nightmare.
I am not an Access expert, but is there a way that the
Unit Cost can be calculated and stored in the table when
an item is added or changed?
Thanks.