ms access - time query for vb6 and msaccess -

-

query for VB6 and MS Access

Table: - 

  user ID Logdata log Time 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

as the need to demonstrate: - 

  user ID Logdet log Time Logdata log Time 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

a #User to use a sub-query Something like, need to find the next date:

TeTime, (Top 1 TB Stack Overflow TimeTime 2 datLogDateTime FROM tblStackOverflowTimeQuery TBSTKOVERflatimetry2 where TBSTIC overs Flotimekting. LngUserId = tblStackOverflowTimeQuery2.lngUserId and tblStackOverflowTimeQuery2.datLogDateTime & gt; tblStackOverflowTimeQuery.lngUserId, tblStackOverflowTimeQuery.datLogDateTime ordered by tblStackOverflowTimeQuery2.datLogDateTime from tblStackOverflowTimeQuery ordered by tblStackOverflowTimeQuery.datLogDateTime) as datEndDateTime; 
  lngUserId datLogDateTime datEndDateTime 1 2010/01/01 09:00:00 2010/01/01 10:00:

that will give the following: 00 1 01/01/2010 10:00:00 01/01/2010 11:29:00 1 01/01/2010 11:29:00 02/01/2010 10:00:00 1 02/01/2010 10: 00:00 2 02/01/2010 22:00:00 03/01/2010 11:00:00 2 03/01/2010 11:00:00

Which is not at all That's what you wanted, but it's a start.

It would be easiest to work using these codes, but it will depend on how you want to use it. There is probably nothing in your data to indicate that the entry is started and that is the end.


Comments

Post a Comment