水晶报表，打开行集失败问提；急急急急急急急

carl_8888 2006-11-10 02:55:00

select cc.customer_code,cc.customer_name,
oo.customer_code + oo.customer_year + oo.customer_serial as customer_bill,
pp.product_name,pps.product_style_name,ppc.product_color_code,ood.out_price as price,
(convert(int,ood.total_count) / convert(int,pp.box_content) / convert(int,pp.chest_content)) as chest_counts,
(convert(int,ood.total_count) / convert(int,pp.box_content) % convert(int,pp.chest_content)) as box_counts,
(convert(int,ood.total_count) % convert(int,pp.box_content)) as counts,
pp.chest_cubage as ch_cu, pp.box_cubage as ch_bo, wwl.location_name,wwl.location_code,
oo.out_warehouse_date
from OWM_OutWarehouse oo
left join CM_Customer cc on oo.customer_id = cc.customer_id
left join OWM_OutWarehouse_Detail ood on oo.out_warehouse_id = ood.out_warehouse_id
left join PM_Product pp on ood.product_id = pp.product_id
left join PM_Product_Style pps on pp.product_style_id = pps.product_style_id
left join PM_Product_Color ppc on pp.product_color_id = ppc.product_color_id
left join WM_Warehouse_Record wwr on ood.warehouse_record_id = wwr.warehouse_record_id
left join WM_Warehouse_Location wwl on wwr.warehouse_location_id = wwl.location_id

错误如下：

打开行集失败。
详细资料： 42000：[Microsoft][ODBC Microsft Access Driver] 语法错误在查询表达式‘(convert(int,ood.total_count) / convert(int,pp.box_content) % convert(int,pp.chest_content)’中。

...全文