VBA Excel Question

[rudevincy]

I have a table in access that with VBA it pull data into my excel.

For cell O3, VBA my code is

strSQL = "Select [Name] " & _
"FROM [Product Table] " & _
"WHERE [Sales Consultant Name] = '" & Spinner & "'" "

Set rs = db.OpenRecordset(strSQL)

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

End With

Is there a way to pull an Product score from the Product Table based on what the value of cell O3 is using VBA code?

Please Help!!

 

[xld]

Try tis

strSQL = "Select [Name] " & _
			"FROM [Product Table] " & _
			"WHERE [Sales Consultant Name] = '" & Spinner & "' AND " & _
			"          [Product] = '" & Range("O3").Value & "'"

Set rs = db.OpenRecordset(strSQL)

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

End With