判断二个字段重复，然后删除。

1、建立一个【保留查询】:

SELECT Sheet1.销售人员, Sheet1.品名, First(Sheet1.数量) AS 数量, First(Sheet1.单价) AS 单价, First(Sheet1.销售金额) AS 销售金额
FROM Sheet1
GROUP BY Sheet1.销售人员, Sheet1.品名;
2、建立一个【不保留查询】:

SELECT *
FROM Sheet1 AS a
WHERE (((Exists (select * from 保留查询 as b where b.销售人员=a.销售人员 and b.品名=a.品名 and b.数量=a.数量 and b.单价=a.单价))=False));
3、建立删除查询:

DELETE *
FROM 不保留查询;
4、点击删除查询即可。