tags:

views:

6

answers:

0
Q: 

time query for vb6 and msaccess

Query for VB6 and MS Access

Table:-

         User Id       LogDate       LogTime 

            1            1/1/2010      9:00  

            1            1/1/2010     10:00   

            1            1/1/2010     11:29  

            1            2/1/2010     10:00

            2            2/1/2010     22:00

            2            3/1/2010    11:00

Need to display as:-

             User Id   LogDate   LogTime   LogDate     LogTime   

             1       1/1/2010  9:00    1/1/2010        10:00   

             1       1/1/2010  11:29   2/1/2010        10:00  

             2       2/1/2010  22:00   3/1/2010        11:00

related questions

Unix gettimeofday() - compatible algorithm for determining week within month?
How do I convert a date/time to epoch time (aka unix time -- seconds since 1970) in Perl?
calculate elapsed time in flash
time.sleep -- sleeps thread or process?
Elapsed time without considering weekends and bank holidays in Java
What languages do date, time, and calendar operations really well?
Measure Total Network Transfer Time from Servlets
Time Parsing in Flex
How can I calculate time schedules (for free)?
What is your choice for a Time Managment Solution?
How can you insure your code runs with no variability in execution time due to cache?
How do you measure the time a function takes to execute?
Resetting detection of source file changes
How to parse relative time?
What is the simplest way to find the difference between 2 times in python?
Datetime arithmetic with a string in Ruby
What should we do to prepare for 2038?
What is the most efficient way to populate a time (or time range)?
“rusage” statistics
If I have a PHP string in the format YYYY-DD-MM and a timestamp in MySQL, is there a good way to convert between them?
How to display "12 minutes ago" etc in a PHP webpage?
Dealing with PHP server and MySQL server in different time zones
Design debate: what are good ways to store and manipulate versioned objects?
Help with CRON jobs?
How can I determine a web user's time zone?