技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 16023
|
5#
發(fā)表于 2012-9-21 13:41:57
|
只看該作者
本帖最后由 Henry D. Sy 于 2012-9-21 13:42 編輯
- Public Function gValue(strWeek As String) As Double
- Dim rs As New ADODB.Recordset
- Dim strSQL As String
- Dim tempVa As Double, tempVb As Double
- strSQL = "select top 2 實(shí)際價(jià)值 from sheet1 where 周期<='" & strWeek & "' order by 周期 desc"
- rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockReadOnly
- tempVa = rs(0)
- If rs.RecordCount <= 1 Then
- tempVb = 0
- Else
- rs.MoveNext
- tempVb = rs(0)
- End If
- gValue = tempVa - tempVb
- rs.Close
- Set rs = Nothing
- End Function
復(fù)制代碼- SELECT Sheet1.周期, Sheet1.設(shè)計(jì)價(jià)值, Sheet1.實(shí)際價(jià)值, gValue([周期]) AS 每周價(jià)值
- FROM Sheet1;
復(fù)制代碼 |
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒(méi)有帳號(hào)?注冊(cè)
x
|