Hello,

I have created a database. I have a table for Work Orders and a table for
Techs that are assigned the various work orders. I have a report that shows
the work order and has a field from the Techs table that shows the tech
assigned to the work order. Currently i have =[First Name] & " " & [Last
Name]. It has been brought to my attention that sometimes work orders have
2-3 techs assigned to the one work order. I need to know how I can create an
expression in the report that would look for a specific work order number and
display all the techs assigned to that work order when the report is run.

Mav

On Mar 11, 11:53*am, MAV <M...@discussions.microsoft.com> wrote:
> Hello,
>
> I have created a database. *I have a table for Work Orders and a table for
> Techs that are assigned the various work orders. *I have a report that shows
> the work order and has a field from the Techs table that shows the tech
> assigned to the work order. *Currently i have =[First Name] & " " & [Last
> Name]. *It has been brought to my attention that sometimes work orders have
> 2-3 techs assigned to the one work order. *I need to know how I can create an
> expression in the report that would look for a specific work order numberand
> display all the techs assigned to that work order when the report is run.
>
> Mav

Depends on how your tables are set up. Do you have a "WorksOn" table
that is a child of the Work Order? If you do it that way, you can use
fConcatCHild or use a subform/report