自定义函数

SELECT count(pno)
FROM person
WHERE plevel>3 And xplace<=mypower(2,plevel-3)*1 And xplace>=mypower(2,plevel-3)*1-mypower(2,plevel-3)+1;

Public Function MyPower(di As Integer, mi As Integer) As Integer


    Dim iC As Integer
    Dim i As Integer
    iC = 1
    i = 0
    
    For i = 1 To mi
        iC = iC * di
    Next i
    
    MyPower = iC
    


End Function

mi=9997,没有初始化（数据表里 plevel 最大值是6，最小值是0，也就是说 mi的值应该在 1-3间,di 的值传进来啦是 2）