已解决）如何指定文本框的数据
SQL：select Sum(AllMoney) from AdviceListView where ExecTime>='2008-06-01 00:00:00' and ExecTime<='2008-06-30 00:00:00' and OffName='儿科'union all
select Sum(AllMoney) from AdviceListView where ExecTime>='2008-06-01 00:00:00' and ExecTime<='2008-06-30 00:00:00' and OffName='内科'
union all
select Sum(AllMoney) from AdviceListView where ExecTime>='2008-06-01 00:00:00' and ExecTime<='2008-06-30 00:00:00' and OffName='外科'
现有三个文本框，如何使文本框1等于select Sum(AllMoney) from AdviceListView where ExecTime>='2008-06-01 00:00:00' and ExecTime<='2008-06-30 00:00:00' and OffName='儿科'
的结果
文本框2等于select Sum(AllMoney) from AdviceListView where ExecTime>='2008-06-01 00:00:00' and ExecTime<='2008-06-30 00:00:00' and OffName='内科'
文本框3等于select Sum(AllMoney) from AdviceListView where ExecTime>='2008-06-01 00:00:00' and ExecTime<='2008-06-30 00:00:00' and OffName='外科'
Form1.Text1 = Adodc1.Recordset.Fields(0)
只有一个数据，如何修改？
[[it] 本帖最后由 jxawgyl 于 2008-7-19 09:03 编辑 [/it]]
