What is the best way to return a Count of Records that match criteria in a DB?

The only way I know of is to Open the Recordset, MoveLast, and use the RecordCount Property...

Is there a way that I can do a Conn.Execute(SQLStatement) that just returns a Count? i.e. SELECT COUNT(*) FROM Table WHERE Active = 1, etc....

Thanks,
Kevin