Still learning! Appreciate the use of bandwidth ahead of time! Oracle 8.1.4 Data exists in 3 tables tblIdWeeks WeekID,WeekStart, WeekEnd tblIDDates AirID, WeekID,DayNum (0 thru 6),DayDate Leave_Detl_tbl Effective_Dt, Leave_type, Input_AM
existing sql is:SELECT tblIDAirWeeks.WeekStart, tblIDAirWeeks.WeekEnd, tblIdAirDates.AirDayDate, [ORIG_LEAVE_TYPE_CD] & " " & [ORIGINAL_INPUT_AM] AS Expr1 FROM tblIDAirWeeks INNER JOIN (tblIdAirDates INNER JOIN AMS_AHRSADM_LEAVE_DETL_TBL ON tblIdAirDates.AirDayDate = AMS_AHRSADM_LEAVE_DETL_TBL.EFFECTIVE_DT) ON tblIDAirWeeks.AirWkID = tblIdAirDates.AirWkID WHERE (((tblIDAirWeeks.WeekStart)>#12/27/2000#) AND ((tblIDAirWeeks.WeekEnd)<#1/5/2002#) AND ((AMS_AHRSADM_LEAVE_DETL_TBL.INTERNAL_EMPL_ID)="0000000357")); I get data returned like so: WeekStart WeekEnd AirDayDate Expr1 1/21/01 1/27/01 1/23/01 SICKF 450 1/21/01 1/27/01 1/24/01 FLH 450 1/21/01 1/27/01 1/25/01 FLH 450 1/21/01 1/27/01 1/26/01 VAC 450 And would like a result that looks like this: WeekStart MON TUES WED THURS FRI WeekEnd 1/21/01 SICKF 450 FLH 450 FLH 450 VAC 450 1/27/01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).