Good Morning

I have managed, by trial and error, to create a query (SQL below) that retrieves the information needed. However, I have been unable to output the data in 1 record per PROVIDER NUMBER (PRVDR_NUM) table with line 01800 and 01900 displayed in separate fields on the same record.

I would appreciate your suggestions for (1) keeping all individual provider information on one record and (2) other suggestions you might have on the overall query.

SELECT Hosp_1996_ALPHAa.RPT_REC_NUM, Hosp_1996_RPTa.PRVDR_NUM, Hosp_1996_NMRCa.WKSHT_CD, Hosp_1996_NMRCa.LINE_NUM, Hosp_1996_NMRCa.CLMN_NUM, Hosp_1996_NMRCa.ITM_VAL_NUM, Hosp_1996_ALPHAa.WKSHT_CD, Hosp_1996_ALPHAa.LINE_NUM, Hosp_1996_ALPHAa.CLMN_NUM, Hosp_1996_ALPHAa.ALPHNMRC_ITM_TXT
FROM (Hosp_1996_RPTa INNER JOIN Hosp_1996_NMRCa ON Hosp_1996_RPTa.RPT_REC_NUM = Hosp_1996_NMRCa.RPT_REC_NUM) INNER JOIN Hosp_1996_ALPHAa ON Hosp_1996_NMRCa.RPT_REC_NUM = Hosp_1996_ALPHAa.RPT_REC_NUM
WHERE (((Hosp_1996_NMRCa.WKSHT_CD)="S200000") AND ((Hosp_1996_NMRCa.LINE_NUM)="01800" Or (Hosp_1996_NMRCa.LINE_NUM)="01900") AND ((Hosp_1996_NMRCa.CLMN_NUM)="0100") AND ((Hosp_1996_ALPHAa.WKSHT_CD)="S200000") AND ((Hosp_1996_ALPHAa.LINE_NUM)="00200") AND ((Hosp_1996_ALPHAa.CLMN_NUM)="0100"));

Thank you for taking the time to read and consider this request.

Al Charbonneau