How can i get the numbers of records in an access database?

Results 1 to 2 of 2

Thread: How can i get the numbers of records in an access database?

  1. #1
    Ozkan Altuner Guest

    Default How can i get the numbers of records in an access database?

    ...

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: How can i get the numbers of records in an access database?

    SELECT NumberOfRecords = Count(*) FROM Table1<BR>WHERE ...<BR><BR>(To access it with your recordset object, if you did:<BR>Set rs = objConn.Execute(sqlString)<BR><BR>you&#039d just say, rs("NumberOfRecords")<BR><BR>Response.Write "There are " & rs("NumberOfRecords") & " in the table Table1"<BR>

Posting Permissions

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