Another select statement

[GUARO]

L.

Thanks for the replay, but I have a question

how count(*) will help check if a result came back.

I am looking for a particular record last_name (smith) within the table if there is a smith the select statement will bring the record but if not the select statement will nothing is here where I need to check if something came back or not

it seems like count(*) will tell me if there are records on a table. am I missing something

Thanks for battling

[Liquid Metal]

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.