已解决）如何指定文本框的数据

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)
只有一个数据，如何修改？

[ 本帖最后由 jxawgyl 于 2008-7-19 09:03 编辑 ]

搜索更多相关主题的帖子: SQL 文本 数据 ExecTime Sum