I am trying to print out a report in Access 2010 (32bit). I am pulling data from two tables. One of the tables is Employee Information(Name, address, phone) the other table is Employee Vehicle(has multiple values, each employee will have many vehilces (one to many)) What I am after is displaying one employee with their vehicles. I have tried in creating a query for this, and the I get:
Employee A - GMC Truck, Dodge Dart
Employee A, 212 Main Street, Town, City, GMC Truck
Employee A, 212 Main Street, Town, City, Dodge Dart
Employee B, 100 Yonge Strreet, Town, City, Grand Am
Then I tried, create a report with the query to get the information for the employee information then insert list box for the vehicles. But this will display all vehicle information for all employees and not for just that one.
I have attached the tables that I trying to get the reports from and a sample of the report I trying to print.