Dim sql As String
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "c:\成绩.mdb;"
sql = "select * from 学生成绩表 ORDER BY 数学 DESC "
Adodc1.RecordSource = sql
Adodc1.Refresh
Text1 = Adodc1.Recordset("数学")
追问大神,,,我还想问一下取平均值并赋值给TEXT1应该怎么编?
追答取平均值需要绑定控件如:
Set MSHFlexGrid1.DataSource = Adodc1
Text1 = MSHFlexGrid1.TextMatrix(1, 1)