已解决 ····················

可否分享一下解决方案呢

同一张表自查询，可以用内连接。

先把EXCEL表导到ACCESS中，假设ACCESS中表名为Sheet1。Sheet1的主键为系统自动生成的AUTO ID。

SELECT *
FROM Sheet1
INNER JOIN Sheet1 As a
ON Sheet1.ID = a.ID
WHERE Sheet1.Starttime = a.Endtime;