Timestamp Difference

F

Francis Phillips

Hi,

Is it possible to get difference between the timestamps on the same table to
get an indication of time between entries into the same table?

Thanks

Frank
 
M

Michel Walsh

Hi,


If the data is in a field of the table, sure


SELECT a.pk, b.pk, a.timeStamp-b.timeStamp
FROM myTable As a INNER JOIN myTable As b
ON ...


where the ON clause precise which relations has to be validated (between the
records) from which we desire to compute the difference.



Hoping it may help,
Vanderghast, Access MVP
 
Top