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
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