Feb 5 2005, 04:35 AM
I need to create a list of books borrowed by each library member, folowed by the total no. of books borrowed by that memeber... how do i go about totaling up the no. of books that each member has borrowed ??
Feb 5 2005, 05:21 AM
btw i have tried to use the " count " function to count the member's id .. but it dont seems to work ..
Feb 5 2005, 11:58 PM
Welcome to Utter Access!
You need to count the Books when you're grouping on the MemberID.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here