February 2, 200520 yr Excuse me for being dense. I have three fields, Subject, Number_One and Number_Two. I want the max for these two number fields summaries at each change in subject. So I created two summary fields Summary_One, Summary_Two, each set as Max of those number fields. When I place these two fields in my subsummary by Subject, I get correct numbers. Then I tried adding them with another calculation field Added_Number = Summary_One + Summary_Two. However, when I place this field in the subsummary, it do not get what I expect. I get a much larger number, the source of which I haven't found yet. Please let me know my fundamental misunderstanding about subsummary and a calculation field based on summary fields. Thanks again. Just when I think I've figured out this program, I find something that doesn't make sense to me.
Create an account or sign in to comment