SELECT ct.Viewed, e.Emp_Last, e.Emp_First,e.Emp_ID FROM #Request.prefix_db_agency#.communication_to ct, #Request.prefix_db_lookup#.pEmployee e WHERE ct.Comm_Id = '#CommId#' AND e.Emp_Id = ct.Employee_Id AND e.Loc_ID = '#session.AgencyId#' ORDER BY e.Emp_Last, e.Emp_First " /> " /> " & geta.Emp_Last & ", " & LEFT(geta.Emp_First,1) & "." /> " /> " /> " /> -" & DateFormat(geta.Viewed, "mm/dd") & " @ " & LCASE(TimeFormat(geta.Viewed, "hh:mm tt")) & "" /> " /> " /> SELECT e.Emp_Last, e.Emp_First FROM #Request.prefix_db_agency#.Communication c, #Request.prefix_db_lookup#.pEmployee e WHERE c.Comm_Id = '#CommId#' AND e.Emp_ID = c.Record_Created_By AND e.Loc_ID = '#session.AgencyId#'