Getting multiple data into one line for reports

[CrakD]

I have a query that has employees and it has multiple items that are associated with it....
There is an employee information table.

for example:

Equip_rent_ID Employee_Id(query) Liable Equipment
123456 Gutierrez, Chris Nextel Radio
123457 Gutierrez, Chris Flash Drive
___________________________________________________________

Right now the query looks something like this:

Gutierrez, Chris | Nextel Radio
Gutierrez, Chris | Flash Drive

I'd like it to be like this:

Gutierrez, Chris | Nextel Radio | Flash Drive

This way I can waste less space and allow for the datasheet view to be printed out and easier to read.... can anyone help? There is probably an easy fix...but I'm not that proficient in SQL.

 

[Hillary]

Open Report in Design view>Right click on the gray box next to Details>Sorting and Grouping.

Select [Employee_ID] for the Group and set Group Header to yes. Close the Sorting and Grouping.

On the report, bring [Employee Name] into the Group.

Put [Liable Equipment] in the Details section. Make sure the Detail section is set to Can Grow in its properties.

I hope this helps.


Hillary

 

[CrakD]

It worked great...Thanks!