This is the CT query:
TRANSFORM Sum(qryDailyLeadsShort.CountOffldOrderID) AS SumOfCountOffldOrderID
SELECT lkptblDays.fldDay AS [Day], Format([cfdate],"dd-mmm") AS [Date]
FROM (lkptblSupplyFit INNER JOIN qryDailyLeadsShort ON lkptblSupplyFit.fldSupplyFitID = qryDailyLeadsShort.fldOSupplyFitID)...