客户ID | 分管部门 |
780310 | 销售一部 |
780110 | 销售一部 |
780257 | 销售三部 |
780312 | 销售三部 |
780901 | 销售二部 |
780901 | 销售一部 |
780110 | 销售三部 |
客户ID | 分管部门 |
780110 | 销售一部 |
780110 | 销售三部 |
780901 | 销售二部 |
780901 | 销售一部 |
SELECT sheet1.客户ID, sheet1.分管部门, [销售收入]/DCount("客户id","sheet1","客户id=" & [客户id]) AS 收入 INTO AAA
FROM sheet1
WHERE (((sheet1.客户ID) In (SELECT [客户ID] FROM sheet1 As Tmp GROUP BY ...
Henry D. Sy 发表于 2009-8-19 12:07
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |