creating a table based on fields from three different tables
Posted
by
ozlem
on Stack Overflow
See other posts from Stack Overflow
or by ozlem
Published on 2011-01-07T18:26:04Z
Indexed on
2011/01/08
5:53 UTC
Read the original article
Hit count: 190
ms-access
Hi, I am using MS-Access 2003. I have three tables containing values of w,Q and L. In the Q table I have three fields: country_name, ISIC_code, and Q value. In the L table, there are three fields, country_name, ISIC_code, and L value. And in the w table there are two fields; country_name and w value. Country_names, and ISIC_code might be different for each table. What I want to do is create a new table with the values b(j)=w(i)L(ij)/Q(ij), where i is the country and j is the ISIC_code. So first I will check if the country name and ISIC_code are the same in L and Q tables. If they are equal I will calculate L/Q and then multiply this with w value of the same country if it exists. I appreciate any help.
© Stack Overflow or respective owner