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

Filed under:

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

Related posts about ms-access