能看看那里错了吗？

你试试这个：

select 出库时间,业务员,销售数量,销售总计,成本价,优惠总计,毛利润 from 业务员利润
union ALL

SELECT 业务员利润.出库时间 & " 小计" AS 表达式1,业务员利润.业务员, SUM(业务员利润.销售数量) AS 销售数量,SUM(业务员利润.销售总计) AS 销售总计, SUM(业务员利润.成本价) AS 成本价,SUM(业务员利润.优惠总计) AS 优惠总计,SUM(业务员利润.毛利润) AS 毛利润
FROM 业务员利润

GROUP BY 业务员利润.出库时间 & " 小计"
UNION ALL select "总计", 业务员,SUM(销售数量),SUM(销售总计),SUM(成本价),SUM(优惠总计),SUM(毛利润) from 业务员利润
ORDER BY 出库时间;

是这里少一列——业务员

UNION ALL select "总计", SUM(销售数量),SUM(销售总计),SUM(成本价),SUM(优惠总计),SUM(毛利润) from 业务员利润