Creating a table referring back to summary fields
In one of my database files, I have multiple tables - each referring to a different coin collection of mine. I have tables such as "Standard Coins", "Paper Money", "Special Sets", etc...
I am looking to create a report or table that will create a listing of each table name and their applicable total summary field (I have in each table a field called "Total Value of Collection" that counts the Collectors' Value and sums it up).
It would look like this:
Std. Coins 4532.09
Paper Money 1224.82
Special Sets 54234.19
What is the easiest way to accomplish this?