select l.*,c.*, s.FirstName, s.LastName from KHB_Lead l inner join KHB_LEAD_Status_Code c on l.lead_status_id = c.lead_status_id left join KHB_Security s on l.Assigned_to_StaffID = s.LoginID where deleted = 0 and c.status_sht_name = order by l.lead_id desc select * from KHB_LEAD_Status_Code where status_sht_name =

#qryStatus.Status_Full_Name# Leads

Your delete was succcessful.

Leads

--->
Date Bride Name Fiance Name Email # Rooms Venue Location Status Assigned To View
#dateformat(qryLead.Date_Created, "mm-dd-yyyy")# #qryLead.Bride_FName# #qryLead.Bride_LName# #qryLead.Fiance_FName# #qryLead.Fiance_LName# #qryLead.Email# #qryLead.Estimated_Rooms# #qryLead.VenueLocation#
#qryLead.Status_Full_Name#
#qryLead.FirstName# #left(qryLead.LastName,1)#

#qryCampaign.Title#



#Numberformat(qryCampaign.totalSent,",")#