Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Subtracting two time values in the same field
0 views
Skip to first unread message
lou.co...@elementalperception.com
May 30, 2007, 2:43:21 PM5/30/07
to
I have a table called SwipeRecords that stores a userid, eventname,
and eventtime. I'm using Event names such as GroupIn and GroupOut.
For a particular userid, I need to be able to subtract the GroupOut
timestamp from the GroupIn timestamp. These are essentially the same
field. Any ideas would be greatly appreciated. I should also add
that this is an ADP, not an MDB.
and eventtime. I'm using Event names such as GroupIn and GroupOut.
For a particular userid, I need to be able to subtract the GroupOut
timestamp from the GroupIn timestamp. These are essentially the same
field. Any ideas would be greatly appreciated. I should also add
that this is an ADP, not an MDB.
Thanks
0 new messages