Hi, I'm having a problem with a sub summary calculation that I though should be pretty straight forward but apparently not. I have found set of records sorted by a field named L# (our job number). Each L# may have multiple records but the list generated shows one instance of each, exactly as planned. One of the fields named # Plates, a calculation, represents the number of colors per job. I'm trying to get a grand total of colors that does not include the multiple records, only the one instance of each L# that I can see. Dropping a copy of # Plates in the Grand Summary gives me a count of the entire found set.
Is there a "Jobs" table where there is only 1 record per job? Sounds like L# is in a child table since you describe multiple records for the same Job. If you do not have a Jobs table, you should. # Plates should be in the Jobs table based on how you have described it (one value per Job), although it sounds like you have it in the child table where it is redundant (which is the problem).
If the report is only showing 1 line per job, base it on the Jobs table. If # Plates were also in Jobs, it could be summarized and would no longer be double-counted as it is now.