I'm still new at this so please bear with me.
I've set up my personnel database and it's working amazingly well. Now, however, I want to be able to quickly get information OUT of it.
Here's my relationship graph:
I just want to create a report that shows me how many reviews an employee has gotten. Ideally I'd like to put a button on every employee's Reviews tab, push it, and be able to print off a report. I'd especially like to be able to print a report to see how many 5-star reviews they've gotten on Yelp or A's on Angie's List. But for now, I'd just like to figure out how to get the damn thing to work. Right now when I run through the little layout/report wizard it just gives me a list of employees with one review. I can't even get off the ground here. It seems a little bizarre that creating useful reports with a relational, multiple-table database would be such a carefully guarded secret.
Any help is appreciated. Thank you.