URGENT!!! Query text & number values from the other tables

[ctien]

To whom it may concerns:

I ugrently need to create a query to show the result as follows: Please explain in details or example to me how to do it in MS Access 2007? Maybe SQL or Query Design?

Thanks a lot in advance.

Calvin

I have three tables as the following:

product
-------------------------------------------------------------
prod_id, description, margin, market_value

1 , prod1, 0.5, high
2 , prod2, 0.2, medium
3 , prod 3, 0.4, low

Margin
-------------------------------------------------------------
minium, weight
0.0 , 1
0.3 , 3
0.5 , 5

Market
-------------------------------------------------------------
value, weight
Low , 2
Medium , 3
High , 7

I need to create a query to show the below result
prod_id, description, margin, margin_weight, market_value, market_weight, subweight (margin_weight * market_weight)
1 , prod1, 0.5, 5, high , 7, 35
2 , prod2, 0.2, 1,medium, 3, 3
3 , prod 3, 0.4, 3,low, 2, 6