How have you set up your tables? This will be a key detail to telling you how to do this.
In general, you're describing a summary report. If you're interested, here's a link to a tutorial about creating summary reports:
I've been getting help from some people regarding the table setup but I'm not quite sure how they did everything. Again, I'm as beginner as it gets. What information about table setup do you need?