vb6.0+win2000+access,fORM1中,求sum并赋值!
问题:如何把"select SUM(FPJE) from fp "合计的结果给:text1.text
Data1.RecordSource = "select SUM(FPJE) from fp "
Data1.Refresh
text1.text=data1.recorderset(0)
我这样做出错了!请指教!
问题:如何把"select SUM(FPJE) from fp "合计的结果给:text1.text
Data1.RecordSource = "select SUM(FPJE) from fp "
Data1.Refresh
text1.text=data1.recorderset(0)
我这样做出错了!请指教!
改为:
text1.text=data1.recorderset.fields(0)
试试
Data1.Refresh
在TEXT1。TEXT中就可以看到计算结果了!