MS Access query for time
- by nisha
following data and using MS Access with VB6
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
Need Output as in below 6 columns:-
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