求高手解答 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Select Case e.DataCol.name
    Case "交款日期"
        If e.DataRow.IsNull("交款日期") Then
            e.DataRow("年") = Nothing
            e.DataRow("月") = Nothing
        Else
            Dim y,m,d As Integer
            DateYMD(e.DataRow("交款日期"),Date.Today,y,m,d)
            e.DataRow("年") = y
            e.DataRow("月") = m

            Dim A As Double = e.DataRow("交款金额")
            Dim fh As Double = 0
            Dim sum As Double = 0
            For i As Integer = 0 To y*12+m-1
                If sum Mod 10000 = 0 Then
                    fh = (A + sum) * 0.1
                End If
                sum += fh
            Next
            e.DataRow("累计返券") = sum
        End If
End Select

主题：求高手解答