A Empty Field

[rudevincy]

Hello,

How do you in VBA Excel code do you say to pull the [Product] score only where the [Name] is empty.

PLEASE HELP!!

This is what I have:

strSQL = "Select [Name] " & _
"FROM [Product Table] " & _
"WHERE [Product Advisor Sales Consultant Name] = "" AND " & _
" [Dealer Name] = '" & Range("O3").Value & "' AND [TIME] = '1 Month Average' "

Set rs = db.OpenRecordset(strSQL)

With rs
If Not .BOF Then
.MoveLast 'Must do the movelast command to get the recordcount
.MoveFirst
Cells(13, 17).CopyFromRecordset rs, .RecordCount
End If

End With

 

[Andrew Poulsom]

Is it?

[Dealer Name] IS NULL

 

[rudevincy]

Yes that worked thank you very much