还是以前的老问题没有解决，怎么对表中的字段求和

<%
sql="select sum(Amt) as total from Order where UID = rs('ID') "
respounse.write total
%>
这段代码哪儿错了？有没有大侠指点一下？

sql="select sum(Amt) as total from Order where UID = rs('ID') group by UID"