Hi, friend
I have finished selecting the records by where condiction.i want to check whether rs.Field() is empty.
can you help me to express it!
thanks a lot!
grs.MoveFirst
MSChart1.Column = 3
 MSChart1.ColumnLabel = "ESTABFAIL"
 For m = 1 To NumPoints
  MSChart1.Row = m
  'there is wrong with below sentence
  If grs.Fields(3) = Null Then
   MSChart1.Data = 0
  Else
   MSChart1.Data = grs.Fields(3)
  End If
  grs.MoveNext
 Next m
創作者介紹
創作者 小吳 VBQA 程式設計討論 的頭像
vbqa

小吳 VBQA 程式設計討論

vbqa 發表在 痞客邦 留言(1) 人氣( 9 )