title: MS Access query for time
body: <p>Following data and using MS Access with VB6</p>
  
  <pre><code>UserID  UserName  LogTime LogDate  
  
  1       S         9:00    21/5/2010  
  1       S         10:00   21/5/2010  
  1       S         11:00   21/5/2010  
  1       S         12:00   21/5/2010  
  1       S         14:00   21/5/2010 
  1       S         17:00   21/5/2010  
  </code></pre>
  
  <p>Need Output as in below 6 columns:-</p>
  
  <pre><code>1     S      21/5/2010 9:00  21/5/2010 10:00  
  1     S      21/5/2010 11:00 21/5/2010 12:00  
  1     S      21/5/2010 14:00 21/5/2010 17:00  
  </code></pre>