Update a column in each Row based on calculation

[sesproul]

Hello,

Here's the issue. Parts made out of different gauge material. Need the information to calculate shipping weights.

Parts table
=========
Partno, FKMaterialID, AREA, Weight

Material Table
===========
MaterialID
WeightPerArea

I gave the Parts table populated, and a materialID selected. How do I run a query to update each row's Weight Column to equal Material.WeightPerArea*Parts.AREA

I know it should be straight forward, but I'm running into a wall on this one.


thanks

Steve

[maximus]

link FKMaterialId of the Parts table with MaterialId of Materials Table. (I think you have already done that if not do it)
Open a query in design View.
From the Menu Bar-Query-Select Update Query.
From Table List Select Both Tables Parts and Materials.
In First Column Select Weight From the Parts Field.
In its UpdateTo Row Type the following code:
([material].[WeightPerArea])*([Part].[Area])
Close and save the update query.
Now Run the query.
You will get the result that you want.

if this solves your problem please mark this thread to be solved.

[sesproul]

Thanks for the help - Worked great! Really saved my morning.


Steve