Display/print Report with two tables

[geraldk]

Hello,

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

result

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.

[ssanfu]

You might try using a sub-report.

Remove "tblEmpVehicle" from the query.
Create a query from the table "tblEmpVehicle" ("qryVehicle")
Create a report using "qryVehicle" ("srVehicle") ** sr = subreport**
Use "srVehicle" as a sub report on your main report.

[geraldk]

Thanks for the reply.

Okay creating the subreport worked. The only thing is it's popping up Enter Parameter Value for the query from Employee information. When I return a blank value in the message box all the information is needed. This report is fine for me to bypass I would like the message to not come for the end user.

Any thoughts on this?

[ssanfu]

One of the queries has a parameter. If the query for the sub-report has a parameter, it is not needed. The link between the employee (form) and the vehicle (sub-report) is set in the report/sub-report control properties.

[geraldk]

Found it. It was between the subform and the report.

Thank you for your help.

[ssanfu]

Excellent!!