Thanks. With a bit of tweaking, it works perfectly - the code is here:
SELECT MasterTable.OPERATIVE, MasterTable.DATE, MasterTable.OPERATION, MasterTable.SITE, MasterTable.PLOT, Sum(MasterTable.VALUE) AS Total
FROM MasterTable
GROUP BY MasterTable.OPERATIVE, MasterTable.DATE...