已知表A
Name No Num
A 1 100
B 1 200
A 2 300
B 2 400
求表B
Name Num1 Num2
A 100 300
B 200 400
---------------------------------------------------------------
Suggest to change the name of your columm no into other name as no2
then u can get your result use following sql.
SELECT name,sum(iif(no2='1',num,0)) as num1,sum(iif(no2='2',num,0)) as num2
FROM tb group by name
or
SELECT name,dsum("num","tb","name='"&name&"' and no2='1'") as num1,dsum("num","tb","name='"&name&"' and no2='2'") as num2
FROM tb group by name