Ask Experts Questions for FREE Help !
Ask
    sonalthakker's Avatar
    sonalthakker Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Feb 27, 2007, 07:02 AM
    Query regarding converting column to row in MS Access
    Hello,

    I have table in MS Access as bellow
    Name Date Time In_Out
    X 25/1/07 09:00 AM IN
    X 25/1/07 12:00 PM Out
    X 25/1/07 01:00 PM IN
    X 25/1/07 07:00 PM Out
    Y 25/1/07 12:00 PM IN
    Y 25/1/07 06:00 PM Out
    .

    I want to convert it as bellow


    Name Date T In T Out T In T Out
    X 25/1/07 09:00 AM 12:00 PM 01:00 PM 07:00 PM
    Y 25/1/07 12:00 PM 06:00 PM


    Can any one help me?

    Thanks in advance

    Sonal
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Feb 27, 2007, 07:10 AM
    Your data is in a normalized setup. So you don't want to convert the actual data. Are you just trying to create a report or what?
    sonalthakker's Avatar
    sonalthakker Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Feb 27, 2007, 07:31 AM
    Yes ScottGem your are right. I am trying to generate report.

    Thanks a lot
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Feb 27, 2007, 07:35 AM
    I would suggest that you would be better off using grouping then to try setting up the columns like you wanted. If you group on Employee then date, You will have an easy to read report of time in and out.

    If you really feel you need the columna format, try using a cross tab query. Set the times as the columns and Employee and Date as the Rows.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

Crosstab Query in MS Access [ 1 Answers ]

How can I change the my query to crosstab query.. please see the picture.. http://www.l22l.com/l22l-up-1/8a7081adec.jpg I write this code... how can I change to a crosstab query SELECT SeaTable.location, Count(SeaTable.location) AS CountOflocation FROM SSFMainTable INNER JOIN SeaTable...

Run MS access query as exe [ 1 Answers ]

Hi, I have to run few queries one after another. I created a form, so now I can run them in sequence with just 1 click of a button. It there a way that I can start running those queries by just loading the form and not clicking any button. My main aim is to have a schedule task so Access...

Update Query in Access [ 1 Answers ]

Hi there! How can I update different records differently in one field based on different criteria? Can I use the update query for that? Do I have to use a macro? Thanks for the help!

View more questions Search