Query Results in One Line

  • Thread starter Thread starter ttp
  • Start date Start date
T

ttp

I have (2) tables that I have joined in a query. The link is based on
Order_Num. I would like the results to come back in a single line. But, my
current results are showing as separate lines. Can anyone assist?

Table 1:
ORDER_NUM
1245407

Table 2:
ORDER_NUM ORDER_TYPE TURBINE_TECH LINE_TYPE
1245407 Performance Services - GEII STEAM CMU Line Type
1245407 Performance Services - GEII STEAM CMU Bill Line
1245407 Performance Services - GEII STEAM Flow Line Type

Required Output:

ORDER_NUM ORDER_TYPE TURBINE_TECH LINE_TYPE1 LINE_TYPE2
1245407 Performance Services STEAM CMU Bill Line Flow Line Type

Basically I would like to take from a alphabetical list the 1st and last
line type. Can anyone assist me?
 
After trying to troubleshoot the issue, I find the field which is causing the
output to be displays as 2 separate lines. I have a field which is varied
based upon the following expression:

(IIf((Mid([ERP export]![LINE_TYPE],1,4)="Flow" Or Mid([ERP
export]![LINE_TYPE],1,6)="Eng Fl" Or Mid([ERP
export]![LINE_TYPE],1,3)="CMUl") And Left([ERP
export]![TURBINE_TECH],3)="STE","Steam Flow"," ")IIf((Mid([ERP
export]![LINE_TYPE],1,4)="Flow" Or Mid([ERP export]![LINE_TYPE],1,6)="Eng Fl"
Or Mid([ERP export]![LINE_TYPE],1,3)="CMUl") And Left([ERP
export]![TURBINE_TECH],3)="STE","Steam Flow"," ").

When I add the field expression in design view, the results are displayed on
separate lines - CMU on one row and Flow on another. Without the expression,
it is fine. How can I allow this field to be different values and still have
the results on the same line?
 
revised.....
After trying to troubleshoot the issue, I find the field which is causing the
output to be displays as 2 separate lines. I have a field which is varied
based upon the following expression:

(IIf((Mid([ERP export]![LINE_TYPE],1,4)="Flow" Or Mid([ERP
export]![LINE_TYPE],1,6)="Eng Fl" Or Mid([ERP
export]![LINE_TYPE],1,3)="CMUl") And Left([ERP
export]![TURBINE_TECH],3)="STE","Steam Flow"," ")

When I add the field expression in design view, the results are displayed on
separate lines - CMU on one row and Flow on another. Without the expression,
it is fine. How can I allow this field to be different values and still have
the results on the same line?
Click to expand...


ttp said:
After trying to troubleshoot the issue, I find the field which is causing the
output to be displays as 2 separate lines. I have a field which is varied
based upon the following expression:

(IIf((Mid([ERP export]![LINE_TYPE],1,4)="Flow" Or Mid([ERP
export]![LINE_TYPE],1,6)="Eng Fl" Or Mid([ERP
export]![LINE_TYPE],1,3)="CMUl") And Left([ERP
export]![TURBINE_TECH],3)="STE","Steam Flow"," ")IIf((Mid([ERP
export]![LINE_TYPE],1,4)="Flow" Or Mid([ERP export]![LINE_TYPE],1,6)="Eng Fl"
Or Mid([ERP export]![LINE_TYPE],1,3)="CMUl") And Left([ERP
export]![TURBINE_TECH],3)="STE","Steam Flow"," ").

When I add the field expression in design view, the results are displayed on
separate lines - CMU on one row and Flow on another. Without the expression,
it is fine. How can I allow this field to be different values and still have
the results on the same line?

ttp said:
I have (2) tables that I have joined in a query. The link is based on
Order_Num. I would like the results to come back in a single line. But, my
current results are showing as separate lines. Can anyone assist?

Table 1:
ORDER_NUM
1245407

Table 2:
ORDER_NUM ORDER_TYPE TURBINE_TECH LINE_TYPE
1245407 Performance Services - GEII STEAM CMU Line Type
1245407 Performance Services - GEII STEAM CMU Bill Line
1245407 Performance Services - GEII STEAM Flow Line Type

Required Output:

ORDER_NUM ORDER_TYPE TURBINE_TECH LINE_TYPE1 LINE_TYPE2
1245407 Performance Services STEAM CMU Bill Line Flow Line Type

Basically I would like to take from a alphabetical list the 1st and last
line type. Can anyone assist me?
Click to expand...
Click to expand...
 
Back
Top