Getting RecordCount [Resolved] (almost)

[szlamany]

I'm not understanding what you mean by ran it about 8 times and what you mean by deleting everything.

Are you creating a TEMP TABLE with the rows you want to process? Could you show some real code so I can grasp this a bit better?

I'm not a VBA person - so maybe I'm confusing something in regard to that.

[dglienna]

I just used count() to get a record count, and put it into a table.
Here:

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

After I ran it, I had 8 records in the table, each with a different number of records in it. Then, I was getting the number from the table:

rs.Open "select RecCount from TempTable", cn, adOpenKeyset, adLockOptimistic, adCmdText

I wanted to know what this was returning? Was it the last record, or the first?
I just wanted to know a general rule of thumb as to how it all worked.

Now, all is good, as I delete all records before I write any, so the problem won't arise again. I just wonder what would come up if I didn't delete all of the records each time.

Was it the first record, or the last record?

[RobDog888]

The "SELECT Count(*)" part gets you the number of records in the FarmingTemp table. So you
should have 8 in your RecCount field for all 8 records.

[dglienna]

Hmm. That makes sense, but I thought they were different numbers, and selecting the count only added one record. I'm going to do it again to see exactly what is happening. Thanks.