Finding multiple blank fields

[skydiver]

Access 2003. I have a table with 90+ Field Names. The table currently contains 2000+ records. I would like to run a query that will find any blank fields for the entire table. HELP!!!

 

[WayneRyan]

skydiver,

With that many columns (that's a lot), you should probably use DAO:

Dim rst As DAO.Recordset
Dim i As Long

Set rst = CurrentDb.OpenRecordset("Select * From Your Table")

While not rst.eof and not rst.bof
   For i = 0 To rst.Fields.Count - 1
      If IsNull(rst.Fields(i)) Then
         Debug.print rst.Fields(i).Name
      End If   
      Next I
   rst.MoveNext
   Wend

hth,
Wayne

 

[skydiver]

Hey Wayne! Thanks for your reply. You guys have always been very helpful. Bear with me as the code is a little chinese to me.

Can you elaborate on the following:

Set rst = CurrentDb.OpenRecordset ("Select * From Your Table")

Can you also point me in the right direction as to where I should include this code. I've got code already, but I just want to make sure I input it in the right place.

Thanks again Wayne!