if Hour({TimeSalesPLU.DateHour}) = 10
    then {TimeSalesPLU.NumberOfItems}
    else 0;

{Stock.Variety}

if Hour({TimeSalesPLU.DateHour}) = 10
 and ({Stock.Variety}) = trackedfood
    then {TimeSalesPLU.NumberOfItems}
    else 0;

SELECT *, SalesStock.PLU AS Expr1, Stock.FamilyName AS Expr2
FROM         SalesStock INNER JOIN
                      Stock ON SalesStock.InvCode = Stock.InvCode
WHERE     (SalesStock.PLU = 18065) AND (Stock.FamilyName = N'Trackedfood')

{Stock.FamilyName} = "Trackedfood" and
{TimeSalesPLU.DateHour} >= {?StartingDate} and
{TimeSalesPLU.DateHour} <= {?EndingDate}