Access Query to Check Timestamp

[Meh]

Hi Guys,

I am very new to access, would highly appreciate your help on below,

I have two tables;

1)

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)

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

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.

[ajetrumpet]

I would highly doubt that querying could do this. you will have to use recordsets, I'm sure.