Counting records in a recordset

Results 1 to 2 of 2

Thread: Counting records in a recordset

  1. #1
    Join Date
    Dec 1969

    Default Counting records in a recordset

    MS Access 2000<BR>Isn&#039;t there an object that contains either the current<BR>record number or the total amount of records in a recordset?<BR>Just trying to figure it out. I know rsSrch.recordcount is NOT<BR>working<BR>&#060;%<BR>If not rsSrch.eof Then<BR> Do While not rsSrch.eof<BR> strPid = rsSrch("products") <BR> response.write strPid&", "<BR> test = rsSrch.recordcount<BR> response.write test<BR> rsSrch.movenext<BR> loop<BR>End If<BR>%&#062;

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RTFFAQs

    FAQ# 139

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts