I have a client table. Each client has two races, each race at two levels. I want to report the races, counting the lower-level race twice if need be when the higher-level race is counted only once. If, for instance, a client has one race European/Celtic and the other European/Germanic I want to count Celtic and Germanic once each but European once only, not twice; everything I have thought of yields a double count of European: the higher-level total insists on being the sum of the lower-level totals. The environment is Access 2000.
