you would need to use a nested recordset for this.
in the nested recordset you would use the count function to return the record count.
see the following tutorial for details on nested recordsets:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=12
the W3Schools page has details on using the MySQL Count function
http://www.w3schools.com/sql/sql_func_count.asp