--ACCESS我不熟,试试这样做:
SELECT 项目编号,COUNT(检测编号) FROM (SELECT DISTINCT LEFT(项目编号, 4) AS 项目编号, 检测编号 FROM 检测结果 ) X GROUP BY 项目编号
SELECT 项目编号,COUNT(检测编号) FROM (SELECT DISTINCT LEFT(项目编号, 4) AS 项目编号, 检测编号 FROM 检测结果 ) X GROUP BY 项目编号
--ACCESS我不熟,试试这样做:
SELECT 项目编号,COUNT(检测编号) FROM (SELECT DISTINCT LEFT(项目编号, 4) AS 项目编号, 检测编号 FROM 检测结果 ) X GROUP BY 项目编号
在ACCESS中FROM语句后只能是表,不能是语句:
... FROM (SELECT DISTINCT LEFT(项目编号, 4) AS 项目编号, 检测编号 FROM 检测结果 ) ...