Hi Guys,
I am very new to access, would highly appreciate your help on below,
I have two tables;
1)
Code:
Country Category ENTITY KO Timestamp
Arg CSD centro AND
Arg CSD Norte AR
Arg CSD GBA K
Arg CSD Sur POL
Arg CSD Costa Lee Feb-09
Arg CSD Costa XYZ
The above table has 5 columns and the Timestamp column tells me that the value in Column 'KO' for Column 'ENTITY' Costa changed from 'Lee' to 'XYZ' in Feb-09.
2)
Code:
Country Category ENTITY Jan-09 Feb-09 Mar-09
Arg CSD centro 100 200 300
Arg CSD Norte 101 201 301
Arg CSD GBA 102 202 302
Arg CSD Sur 103 203 303
Arg CSD Costa 104 204 304
The above table shows some numbers from Jan-09 to Mar-09 for same Entity's (The first 3 columns are the same as the first table.)
OUTPUT:
I want to write a query that will join the about two table (By joining the first 3 columns) and give me 'KO' column in the output, with 'Costa' numbers displayed till 'Feb-09' under 'Lee' and in 'Mar-09' under 'XYZ'. (As Below
Code:
Country Category ENTITY KO Jan-09 Feb-09 Mar-09
Arg CSD centro AND 100 200 300
Arg CSD Norte AR 101 201 301
Arg CSD GBA K 102 202 302
Arg CSD Sur POL 103 203 303
Arg CSD Costa Lee 104 204 0
Arg CSD Costa XYZ 0 0 304
Please let me know if I could elaborate on anything else,
Thanks in advance for your help.