total count...AAAAAAAAAAARGGGH!!!

Results 1 to 4 of 4

Thread: total count...AAAAAAAAAAARGGGH!!!

  1. #1

    Default total count...AAAAAAAAAAARGGGH!!!

    I cant for the life of me remember how to do a **** recordcount of the total number of rows within an access db.<BR><BR>I thought it was <BR><BR>"SELECT count(*) from table_name"<BR><BR>RS open<BR><BR>response.write RS.recordcount<BR><BR>Am I losing my mind????

  2. #2
    Join Date
    Dec 1969

    Default RE: total count...AAAAAAAAAAARGGGH!!!

    I think you would do Select * from<BR><BR>but no need to select all the records<BR><BR>Select Count(ID) AS CountOfID From Tablename<BR><BR>Response.Write rs("CountOfID")<BR><BR>You can even add a where clause to that statemenet to limit if needed<BR>Select Count(ID) AS CountOfID From Tablename where fldMember = &#039;Russell&#039;<BR><BR>

  3. #3

    Default nice...

    thanks heaps..<BR><BR>*phew phew*

  4. #4
    Join Date
    Dec 1969

    Default Russel

    I just got back and I posted responses below.<BR><BR>Thanks for the help.

Posting Permissions

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