我用SQL建的表: 表名:yuanliaokucun
字段名:yuanliaobianhao pinming zongrukuliang zongchuliang kucunliang
JFAPP01 聚丙烯 1000 900 100
FLAPP01 聚丙烯 1000 900 100
JFAPS01 聚乙烯 1000 900 100
FLAPS01 聚乙烯 1000 900 100
我怎么样将是聚丙烯的库存量加在一起然后将此数据反馈到一个窗体的text里面
是不是像下面那样?set mrc=cn.execut(select sum(kucunliang),pinming from yuanliaokucun group by pinming)然后怎么将sun(kucunliang)反馈到窗体中?
字段名:yuanliaobianhao pinming zongrukuliang zongchuliang kucunliang
JFAPP01 聚丙烯 1000 900 100
FLAPP01 聚丙烯 1000 900 100
JFAPS01 聚乙烯 1000 900 100
FLAPS01 聚乙烯 1000 900 100
我怎么样将是聚丙烯的库存量加在一起然后将此数据反馈到一个窗体的text里面
是不是像下面那样?set mrc=cn.execut(select sum(kucunliang),pinming from yuanliaokucun group by pinming)然后怎么将sun(kucunliang)反馈到窗体中?
"select sum(kucunliang) as kucunliang,pinming from yuanliaokucun WHERE pinming='聚丙烯'
group by pinming")
text1.text = iif(isnull(mrc!kucunliang)=true,0,mrc!kucunliang)
text1.text=rst!SumOfKucunliang
这句怎么解释?
set mrc=cn.execut(
"select sum(kucunliang) as kucunliang,pinming from yuanliaokucun WHERE pinming='" &text2.text&"'"
group by pinming")
text1.text = iif(isnull(mrc!kucunliang)=true,0,mrc!kucunliang)