I am getting frustrated with a problem i can't figure out. I have a table of marriages. Each record contains many fields including both a groom age, a bride age, a groom's marital status, and a bride's marital status. I need to produce a count (by age group) of the marital statuses of each. The total records pulled is 1000 records. So at the end of the report I should have a count of 2000 marital statuses (1000 brides and 1000 grooms). But for the life of me I cannot figure out how to get this to work. I can only return 1000 rows of data. To make it more complicated, I need to group all of this by age group. 18-20, 21-25, and so on.
So imagine a single record has two ages in it, where the groom is 19, and the bride is 23. How can i get both groups to properly count each age? I was using running totals which are working great from a grand total perspective, but don't work at the group level because i can't evaluate the group membership. Any help is greatly appreciated.