Query design

[Ranger7913]

Need some help on producing a query then a report that would eliminate similar/duplicate data. Specifically if I produce a query on an employee who is connected to multiple records in a related table, I would like to only have the employee info produced one time and all of the related records listed under that employee. I will also be printing a report that will produce multiple employees from the employee table who have multiple records in a related table. Need to know how to hide or not have the employee info show for each record on the related table.

[ranman256]

If you want the emp info to show in the report, then yes put it in the query.
You will get repeating Emp Name, but the related records will be unique.

In the report, GROUP the Emp Name and put that field in the GROUP BAND header. NOT in the detail.
summarize each emp in the FOOTER band if needed.