SELECT count(*) AS zs, round(sum(总重量),2) AS zzl, round(sum(石重),2) AS zsz, round(sum(进货价),2) AS zjhj
FROM 商品
WHERE 类型编号=13 And datediff('d',入库时间,#3/19/2008#)<0 And datediff('d',入库时间,#4/21/2008#)>0;
版本:access 2003 sql语句:SELECT count(*) AS zs, round(sum(总重量),2) AS zzl, round(sum(石重),2) AS zsz, round(sum(进货价),2) AS zjhj FROM 商品 WHERE 类型编号=13 And datediff('d',入库时间,#3/19/2008#)0; 查询则提示记录被删除,当类型编号=19时正常,奇怪了!类型编号为