By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,798 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

Transpose values from rows into columns in my ms access table

P: 1
I have a table like this in msaccess 2007

Expand|Select|Wrap|Line Numbers
  1. RollNo(Text)  LogTime(Date/Time)
  2. 4001          25/03/2015 03:15
  3. 4001          25/03/2015 08:25
  4. 4001          26/03/2015 00:03
  5. 825           25/03/2015 07:30
  6. 825           25/03/2015 11:30
I want to reaarange my data in a query like this:

Expand|Select|Wrap|Line Numbers
  1. RollNo   LogTime1           LogTime2                 LogTime3
  2. 4001     25/03/2015 03:15    25/03/2015 08:25       26/03/2015 00:03
  3. 825      25/03/2015 07:30    25/03/2015 11:30
Mar 26 '15 #1
Share this Question
Share on Google+
1 Reply


Seth Schrock
Expert 2.5K+
P: 2,951
What is the maximum number of LogTimes that you would have?
Mar 26 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.