select c.CampID, c.Title, c.EMSubject, s.Sentdate, s.totalsent, s.totalopens, s.totalclicks from statsEmailSummary s inner join Campaign c on s.Campid = c.CampID and c.Advertiser_ID = #Session.LimitAdvertiserID# where s.totalsent > 10 order by s.sentdate desc Campaigns

Campaigns

Search

Date Campaign Name Sent >Action

#dateformat(qryCampaign.Sentdate, "mm-dd-yyyy")#

#qryCampaign.Title#



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