如何调出查到的数据????
xx110 2003-08-20 11:22:17 我的代码如下:
Public Function VS(R As Single, T As Single) As Single
Dim db As Database
Dim rs As Recordset
Dim StrA As String
Dim i%, j%, TotalNO%
Const Co As Single = 0.6655
Const k2 As Single = 1.009
Const So# = 0.003681
Dim p As Single
StrA = "Data/孔板流量计.mdb"
StrA = OpFile(StrA)
Set db = OpenDatabase(StrA)
Set rs = db.OpenRecordset("Sheet1")
rs.MoveLast
TotalNO = rs.RecordCount
For i = 1 To TotalNO
.....
Next i
p = 997 * 351.1 / T
VS = Co * k1 * k2 * So * Sqr(2 * 9.8 * R * p / 0.001)
End Function
我想通过R在数据库中找到 K1(数据库中只有,R和k1这两个量),并且取出k1作为计算中的参数。
请问我怎么取出k1??? 能帮我把程序补充完整吗???谢谢!