Hi
I have the code below that allows me to test the result of a query
The query is a crosstab and pivots on months
what i want to do is check if the field december is different to blank
and if so increment the textbox.
the problem is  
1. if no value for december the field is not included in the result
2. assuming i can get over 1st problem how can i check if field
december is different to space?

  Dim db As DAO.Database
  Dim qd As DAO.QueryDef
  Dim rs As DAO.Recordset
  Set db = CurrentDb
  Set qd = db.QueryDefs("monthly_totals_team")
  Set rs = qd.OpenRecordset()
 
  If Not rs.EOF <> 0 Then
     Me.Cboyears = Me.Cboyears + 1
     End If
  On Error Resume Next
  Set rs = Nothing
  Set qd = Nothing
  Set db = Nothing

thanks

kevin