Summaries and value lists?
I seem to be having a bit of a problem figuring out how to pull together a summation for a set of values linked to a value list. Here are the details.
I have one database with two relational tables (one holds project information and the other holds project accomplishment data). For each project that exists there are a number of different accomplishments (benches built, trails cleared, etc.) that are linked to the project ID. And for different projects, the same accomplishment might appear (two projects both have benches). I'd like to create a summary that totals the number of benches built without showing two, Benches Built line. In essence, for the found set of project, I'd like each value in the value list listed just once with the numerical data tallied across all projects.