AnsweredAssumed Answered

Creating a table referring back to summary fields

Question asked by btr94 on Dec 29, 2009
Latest reply on Dec 30, 2009 by philmodjunk

Title

Creating a table referring back to summary fields

Post

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:

 

TABLE                         VALUE

Std. Coins                    4532.09

Paper Money                 1224.82

Special Sets                  54234.19

 etc...

 

What is the easiest way to accomplish this?

Outcomes