I searched through the FAQ's under databases but couldn't find the answer to this. Is there someplace else I can find how to show the number of records displayed from an access database?
...maybe not where you would expect. It's in category Databases, Errors:<BR><BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=139<BR><BR>
SQL="SELECT COUNT(*) AS total_number FROM your_table"<BR>