[PJay]

Originally Posted by chipstone

You can use Access to create the master table including all the variable data entries, and then create an Access query over the database table to isolate what information you want summarized.

Also, since the number of records is so small you can use Excel and create a pivot table from an external data source, namely your access database. The Pivot table will allow you customize the summarized info you may require and it’s dynamic, all you need to do after adding records to the database you refresh the pivot table to include all data to date.

Very helpful, Chipstone. thanks