Cheers anyway! Found if I split Galley etc in to own tables I can do it
That's not likely to be the ideal solution. You can set up a self join relationship that matches records by a user specified date and then you can compute such a total using either the sum function or a summary field to get the specified sub total.
When you split up a table into one table for each date or date range, you end up needing spearate layouts for each and have to enter new tables and layouts for each new date range--which get's very messy over time and can be completely avoided.