SELECT Orders.[Order ID], Sum([Daily Query].[Total Cost]) AS OrderTotal, Sum([Daily Query].[Total Cost]) +IIf([Orders].[Delivery?]=Yes,1.5,0) AS Delivery
FROM [Daily Query] INNER JOIN Orders ON [Daily Query].[Order ID] = Orders.[Order ID]
GROUP BY Orders.[Order ID];