so do it like this:

strSQL="SELECT * FROM TableA
WHERE LastName='Smith'"

run that throught the recordset with the cursor set to static.

once it is open, do a recordset.recordcount and that will give you the count.

Pretty much similar to what I described in the previous post.