请教一个统计查询的语法问题!
For i = 1 To 12
.Open "select sum(fy) as Sfy from tbluseinfo where year(intime) = " & NYear & " and month(intime) =" & i
McrNdsy.Row = i
If .EOF Then
McrNdsy.Data = 0
Else
McrNdsy.Data = .Fields(0) '???????
End If
.Close
Next
运行时程序提示无效的NULL值,可是数据库里面明明是有数据的,不知道是不是语法错误,请知道的朋友帮我看一下!