Query Results in One Line

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?
 
T

ttp

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?
 
T

ttp

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem Adding a field based on expression 1
Define Correct Criteria 1
duplicate results in query 6
Formatting date gives bad results in query 2
More than one criteria value in a query 1
Combo Box Won't Return Results in Query 1
Query that returns one line of data 8
My query only shows results where all fields are have data entered 1

Top