Database question

What's the easiest way to count how many items there is in a dbTable?
I know that I can use something like this:

Do While Not tblMyTable.EOF
      Items = Items + 1
      tblMyTable.MoveNext
Loop

But this takes to much time. Is there a better way?
Olli083097Asked:
Who is Participating?
 
clifABBConnect With a Mentor Commented:
Try this (before you open the table):
Set tblMyTable = db.OpenRecordset("Select Count(*) As Cnt From dbTable")
nNumRecords = tblMyTable.Fields("Cnt")
0
 
clifABBCommented:
Depending on the type of table you open, you could also do this:

tblMyTable.MoveLast
tblMyTable.MoveFirst
nNumRecords = tblMyTable.RecordCount
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.