How to get number of records in the database using recordset

Question

This is a real simple problem but for some reason I haven't been able to figure it out. I am executing a query and I need to get the number of records returned from the query and need to use that number to loop through some operations. I have tried rs.RecordCount where rs is a recordset but receive a -1. What is the function to get the number of rows returned?