I am not familiar with Access but felt it was the best thing to use to create some reports for my company. My questions is how can I create a report that will group the following: Name, Job Title, Location, Hire Date, Years of Service...and then actually list each of the following if an employee has more than one: School, Degree, Area of study.
What is happening is that I get a record for each person that has more than one degree because they have two records in the education table.
Any assistance would be greatly appreciated.