|It's hard to describe without going into so much detail that I end up writing a book... but if I understand your question correctly, I believe you just want to group and count your data in a report. See the site below on how to do that.|
I didn't read completely through the article I linked above, but I still want to mention an easier way of creating reports. If your DB is in a front-end/back-end configuration you will always want to create your reports in the front-end but they will be based on the tables in the back-end. Since your front-end is linked to the back-end, all you need to do is open the linked table that you want to create the report on in the front-end and click on the 'Create' tab and click on the 'Report' button. It will create a report using the table that is open. All you have to do is right-click on the tab of the report, change it to design view and click the 'Group & Sort' button in the menu ribbon.
Another helpful note for you: you can assign forms, reports or just about anything really to a button. So if you want to have a form specifically for reports, you can create a separate button for each report, use a macro to open the report. One more thing, you can put buttons on reports so you can click it to close them. You can also set those buttons to not print when you print the report.
I hope this answers your questions!!!! Let me know if you have any other questions!
Law of Logical Argument: Anything is possible if you don't know what you're talking about.