SELECT tbl_Members.F_Name, tbl_Members.L_Name, tbl_Members.Email, tbl_Department.Dept, tbl_JobTitle.Title, tbl_Type.Type, tbl_Members.IsSuper, tbl_Members.Link, tbl_Members.L_Name + ', ' + tbl_Members.F_Name +' ' + COALESCE(tbl_Members.M_I, ' ') AS Name, COALESCE (tbl_Members.AddInfo, ' ') AS EAddInfo, COALESCE (tbl_Credentials.Credentials, ' ') AS ECred, COALESCE(tbl_Members.Link, ' ') AS ELink, COALESCE(tbl_Members.Email, ' ') AS Eemail FROM tbl_Members INNER JOIN tbl_Department ON tbl_Members.Dept_ID = tbl_Department.Dept_ID INNER JOIN tbl_JobTitle ON tbl_Members.Title_ID = tbl_JobTitle.Title_ID INNER JOIN tbl_Type ON tbl_Members.Type_ID = tbl_Type.Type_ID LEFT OUTER JOIN tbl_Credentials ON tbl_Members.Credentials_ID = tbl_Credentials.Credentials_ID WHERE tbl_Department.Dept = 'Administrative' ORDER BY tbl_Members.Sort, Name

Administrative Staff

* #Name# #Name# #ECred# #Title#, #EAddInfo# #EAddinfo#, e-mail
* #Name# #Name#, #ECred# #Title#, #EAddInfo# #EAddinfo#, e-mail
SELECT tbl_Members.F_Name, tbl_Members.L_Name, tbl_Members.Email, tbl_Department.Dept, tbl_JobTitle.Title, tbl_Type.Type, tbl_Members.IsSuper, tbl_Members.Link, tbl_Members.L_Name + ', ' + tbl_Members.F_Name +' ' + COALESCE(tbl_Members.M_I, ' ') AS Name, COALESCE (tbl_Members.AddInfo, ' ') AS EAddInfo, COALESCE (tbl_Credentials.Credentials, ' ') AS ECred, COALESCE(tbl_Members.Link, ' ') AS ELink, COALESCE(tbl_Members.Email, ' ') AS Eemail FROM tbl_Members INNER JOIN tbl_Department ON tbl_Members.Dept_ID = tbl_Department.Dept_ID INNER JOIN tbl_JobTitle ON tbl_Members.Title_ID = tbl_JobTitle.Title_ID INNER JOIN tbl_Type ON tbl_Members.Type_ID = tbl_Type.Type_ID LEFT OUTER JOIN tbl_Credentials ON tbl_Members.Credentials_ID = tbl_Credentials.Credentials_ID WHERE tbl_Department.Dept = 'Scientific' AND (tbl_Type.Type <> 'Volunteer') ORDER BY tbl_Members.Sort, Name

Scientific Staff

* #Name# #Name# #ECred# #Title# #EAddInfo# #EAddinfo#, e-mail
* #Name# #Name#, #ECred# #Title#, #EAddInfo# #EAddinfo#, e-mail