expression issue

I am rather new working with access. I have run into a problem with some
ways to work in some expressions with my database. The database is for a
manufacturing company and the expressions i am going to have to work out are
long the lines of, in Finished product A it takes Xamount of raw product A
Xamount raw product B and Xamount raw product C. I know expressions are not
ment to built inside of tables but i am having a hard time figuring out a way
of subtracting from raw materials and then adding to finishing materials
suggestions on where i should go from here thanks. -Ryan

You should have a product table which includes raw and finished products and
perhaps stages in between.

There shouuld also be a where used table of some type which will link the
primary key (PK) of a component in the product table with with the PK of
the where used product in the product table. This linking table is where the
relationship beween the raw product and the finished product is described.
It should hold the information of how much raw product goes into each unit
of finished product. There will probably be a quantity field and a unit of
measure field (UOM). e.g 6 units of nuts and bolts, 0.76 litres of paint, .5
cubic metre of foam etc.

The calculations of how much raw materials you require to make 7 units of
finished product should be done as a calculation or expression, same thing,
in a query and displayed in a form on a report. Expressions do not belong in
tables.

HTH

"Ryan" wrote in message
...
I am rather new working with access. I have run into a problem with some
ways to work in some expressions with my database. The database is for a
manufacturing company and the expressions i am going to have to work out
are
long the lines of, in Finished product A it takes Xamount of raw product A
Xamount raw product B and Xamount raw product C. I know expressions are
not
ment to built inside of tables but i am having a hard time figuring out a
way
of subtracting from raw materials and then adding to finishing materials
suggestions on where i should go from here thanks. -Ryan