This is my first post but I have frequented the forums for some time. The project I'm working on right now has me a little stumped and am looking for some input on how to get the report started.
I have a database with a user table [id, name] and 4 tables for different types of exams the users take. Each exam table (exam1, exam2, exam3, exam4) has fields [userid, date taken, score]. The report would print the user id, name and list the exam information for that user, but I would like each page to be a different user (such as an individual user assessment report).
I would just like some ideas on how I should set up the sections and grouping to acheive this. Thanks in advance for the input!