Results 1 to 2 of 2
  1. #1
    Meh is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    3

    Access Query to Check Timestamp

    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.
    Last edited by Meh; 12-21-2010 at 10:41 AM. Reason: Table Alignment

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    I would highly doubt that querying could do this. you will have to use recordsets, I'm sure.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Installed? How to check it online.
    By Thopaga in forum Access
    Replies: 2
    Last Post: 12-09-2010, 02:24 PM
  2. Check box help in access 2003 [VB]
    By empyrean in forum Programming
    Replies: 2
    Last Post: 10-29-2009, 04:34 PM
  3. Replies: 2
    Last Post: 11-11-2008, 01:12 PM
  4. Replies: 0
    Last Post: 11-06-2008, 12:29 PM
  5. Access Timestamp...
    By HMel in forum Access
    Replies: 4
    Last Post: 08-19-2008, 01:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums