SELECT dbo.tblBoardMembers.BrdMemberID, dbo.tblBoardMembers.FirstName, dbo.tblBoardMembers.MidName, dbo.tblBoardMembers.LastName, dbo.tblBoardMembers.BM_Current, dbo.tblBoardPositions.Position AS PositionBy, CASE dbo.tblBoardPositions.Position WHEN 'Chairperson' THEN 0 WHEN 'Vice-Chairperson' THEN 1 WHEN 'Employee Representative' THEN 2 WHEN 'Employer Representative' THEN 3 END AS SortBy, dbo.tblBoardMembers.Homecontact, dbo.tblBoardMembers.Title, dbo.tblBoardMembers.Organization, dbo.tblBoardMembers.OrgAbbrev, dbo.tblBoardMembers.WorkContact, dbo.tblContactInfo.City, dbo.tblContactInfo.Prov, dbo.tblContactInfo.StreetAddress2, dbo.tblContactInfo.StreetAddress1, dbo.tblContactInfo.PostalCode, dbo.tblContactInfo.Phone1, dbo.tblContactInfo.Fax1, dbo.tblContactInfo.Extension1, dbo.tblContactInfo.Phone2, dbo.tblContactInfo.Fax2, dbo.tblContactInfo.Extension2, dbo.tblContactInfo.CellPhone, dbo.tblContactInfo.Email1, dbo.tblContactInfo.Email2, dbo.tblContactInfo.Website FROM dbo.tblBoardMembers LEFT OUTER JOIN --> not sure what this should be dbo.tblContactInfo ON dbo.tblBoardMembers.Homecontact = dbo.tblContactInfo.ContactID AND dbo.tblBoardMembers.WorkContact = dbo.tblContactInfo.ContactID INNER JOIN dbo.tblBoardPositions ON dbo.tblBoardMembers.PositionID = dbo.tblBoardPositions.BrdPositionID WHERE (dbo.tblBoardPositions.Position <> 'N/A') AND (dbo.tblBoardMembers.BM_Current <> 'PAST') ORDER BY dbo.tblBoardMembers.LastName, CASE dbo.tblBoardPositions.Position WHEN 'Chairperson' THEN 0 WHEN 'Vice-Chairperson' THEN 1 WHEN 'Employee Representative' THEN 2 WHEN 'Employer Representative' THEN 3 ENDMathieu Alexandre Cupryk www.omegalove.com

Hi Alexandre, This is SSRS forum. Try adding your request to the below t-sql forum, http://social.msdn.microsoft.com/Forums/en/transactsql/threads Thanks KumarKG, MCTS