I have 6 tables, with a field relating to a change number, then fields starting Jan06 through to Jan 2015, the tables record resource useage for every month through this time period for a change. As you can see this is a lot of numeric fields.
The problem I have is that I now want to be able to provide totals per month for all 6 tables. Maybe in a report or on screen.
Any ideas as to the best way to do this?
The problem I have is that I now want to be able to provide totals per month for all 6 tables. Maybe in a report or on screen.
Any ideas as to the best way to do this?
