我正在尝试在MS Access中执行以下查询,以找到两个时间之间的差异。时间格式为例如开始时间8:00和结束时间14:00。但是,我在查询中遇到错误,请帮我修复。
PARAMETERS [Enter Date] DateTime;
SELECT
M.CompanyID AS Emp_ID,
MIN(H.EventTime) AS Attending,
MAX(H.EventTime) AS Leaving,
Format( (Leaving-Attending), "hh:mm:ss") AS TotalHrs
FROM
Member AS M
LEFT JOIN History AS H ON M.UserID = H.EventUserID
AND
( Format( [EventDate], "dd/mm/yyyy" ) ) = [Enter Date]
WHERE
companyId NOT IN (select companyid from exceptions)
GROUP BY
M.CompanyID, EventDate
ORDER BY
CompanyId;
Ayha
Format( (MAX(H.EventTime)-MIN(H.EventTime)), "hh:mm:ss")
? - user554546