有关统计的问题
表1.dbf
CPXH SL (还有其它字段)
med1 10
med1 10
med3 10
med3 10
med9 10
我想要的查询结果是:
CPXH SL
med1 20
med3 20
med9 10
以下是部分源码(运行时grid1一片空白),我也不知道错在哪,帮忙看看吧:
sele cpxh as 产品型号,sum(sl) as 数量;
from cpwxjl;
where fcrq>thisform.date1.value and fcrq<thisform.date2.value;
into cursor yue
thisform.pageframe1.page1.grid1.recordsource='yue'
thisform.pageframe1.page1.grid1.refresh