Getting RecordCount [Resolved] (almost)

[dglienna]

How do I refer to the Count() field in my RS ? I forgot that I had already done it with the complex query. Now I need it for the simple query. If I can add the count like szlammy said, I'd like to do that.

EDIT: I have this

rs.Open "Delete TempTable .* from TempTable ", cn, adOpenKeyset, adLockOptimistic, adCmdText
 
  rs.Open "INSERT INTO TempTable (RecCount) " & _
     "SELECT  Count(*)" & _
     "From FarmingTemp", cn, adOpenKeyset, adLockOptimistic, adCmdText
  RecCount = rs.Fields(1)

So how do I get it back out. I've also tried RecCount = rs.fields("RecCount") but that returns an error.