This isn't the complete solution but it should help you get there
1. Tick the Show checkbox in qryYarn
2. Make a new aggregate query joing qryYarn & qryTarn as follows:
Code:
SELECT DISTINCT qryTani.Date, qryTani.Type, qryTani.PrdName, qryTani.BeamSize, qryTani.Rounds, qryTani.Ends, qryTani.NumberOfBeams, qryTani.BeamWeightLoaded, qryTani.BeamWeightEmpty, qryTani.BeamWeight, Sum(qryTani.TaniWeight) AS SumOfTaniWeight, qryYarn.SumOfQtyFROM qryTani INNER JOIN qryYarn ON (qryTani.Date = qryYarn.PurchaseDate) AND (qryTani.Type = qryYarn.Type)
GROUP BY qryTani.Date, qryTani.Type, qryTani.PrdName, qryTani.BeamSize, qryTani.Rounds, qryTani.Ends, qryTani.NumberOfBeams, qryTani.BeamWeightLoaded, qryTani.BeamWeightEmpty, qryTani.BeamWeight, qryYarn.SumOfQty
HAVING (((Sum(qryTani.TaniWeight))<=[SumOfQty]));
Adjust as appropriate for your needs then use to create your report
BTW As there are a lot of identical tables in your 2 queries you could probably get the same result in one query
I'll leave that to you