Sql or VB for Access
Posted
by vijay
on Stack Overflow
See other posts from Stack Overflow
or by vijay
Published on 2010-04-21T17:32:27Z
Indexed on
2010/04/21
17:43 UTC
Read the original article
Hit count: 522
ms-access
I Have a table in Access as below
SI Number Time
1.14172E+20 13:30:35
1244066650 18:58:48
1244066650 19:03:12
1244066650 19:05:50
01724656007_dsl 22:15:20
01724656007_dsl 22:18:00
01724656007_dsl 22:24:28
1141530407 10:27:49
1141530407 10:29:13
And require output in the same table is
SI Number Time Diff
1.14172E+20 13:30:35
1244066650 18:58:48
1244066650 19:03:12 0:04:24
1244066650 19:05:50 0:02:38
01724656007_dsl 22:15:20
01724656007_dsl 22:18:00 0:02:40
01724656007_dsl 22:24:28 0:06:28
1141530407 10:27:49
1141530407 10:29:13 0:01:24
I require as if 1st record in SI Number column is equals to 2nd record than record 2 of time column -record 1 of time column in Diff column record 2 record 1 will remain blank
Urgent help required Vijay
© Stack Overflow or respective owner