Ok bear with me I'm not great with Access! Basically I have a report which has the following headings
Project, Area, Cap/Rev, Actual, Budget, Forecast
The report is sorted via Area. (North, Central and South). I then have the report subtotalling using footers to bring through North Cap, North...