请帮忙看下这段代码里 哪里错了？

[regsBBS]

SELECT banci AS p1, count(id) AS p2, sum(cint(p4)) AS p3
FROM t_a_onlineDetail
GROUP BY banci;

[of123]

p4 是已经存在的字段吗？什么类型？如果是数值：

SELECT banci AS p1, count(id) AS p2, sum(p4) AS p3
FROM t_a_onlineDetail
GROUP BY banci;

[king06]

sql中没有cint()函数,这是VB里的

[赵4老师]

cint(p4)改为CAST(p4 as int)

[regsBBS]

如果在access里呢？也是这样吗？