Access2007创建如下所需报表

1.销量sql:

SELECT Sheet1.编码, Sheet1.名称, Sum([数量]*[单价]) AS 销量
FROM Sheet1
GROUP BY Sheet1.编码, Sheet1.名称;

2.销量比率sql:

SELECT 销量查询.编码, 销量查询.名称, 销量查询.销量, [销量]/[销量之总计] AS 比率
FROM 销量查询, 销量查询总计;

3.省份数sql:

SELECT Sheet1.编码, Sheet1.名称, Count(Sheet1.省份) AS 省份数
FROM Sheet1
GROUP BY Sheet1.编码, Sheet1.名称;

4.客户数sql:

SELECT Sheet1.编码, Sheet1.名称, Count(Sheet1.客户) AS 客户数
FROM Sheet1
GROUP BY Sheet1.编码, Sheet1.名称;