Access Expression builder

  • Thread starter Thread starter MAV
  • Start date Start date
M

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
 
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
Click to expand...

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
 
Back
Top