GROUP BY

[moernoo]

Hi,

I have the following tables:

Tabel 1: "Parts:"

PartID | PartCost
------------------
1 | 0.5
2 | 0.3


Tabel 2: "ConsumedParts"

PartID | Quantity
------------------
1 | 1
1 | 2
2 | 1


Now, i would like to become a table like underneath, that summarizes all parts which are the same and calculate the total cost per part:

PartID | Quantity | RegelPrijs
-------------------------------
1 | 3 | 1.5
2 | 1 | 0.3


Who can help me please?

Thanks in advance

 

[alvechurchdata]

You'll need a query for this. Open the Query Designer, add the two tables and link the two PartID fields by dragging one to the other (the link may already be there). Then drag the fields that you want to the grid. Type Quantity*PartCost as a new column to calculate the price.

Hope that's enough to get you started.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[moernoo]

Hi,

thanks, that multiplication has gotten me started.

Bart