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
> Hi,
>
[quoted text clipped - 5 lines]
>
> Frank