Access Expression builder

[MAV]

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

 

[pietlinden]

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