DSum and Sum

[jt]

=DSum("[NOV2003]","History","[Contract] = 'Y'")

I'm creating a Report that is grouped by Contract...among other groupings. I want to be able to sum the NOV2003 values only if Contract=Y, for each group. Using the expression above gives me the total sum. How can I modify it to give me the sum for each group?

Help?

 

[Tonster]

Create a Sub-Report with the information that you have
already created, then create report to place it in. Next
you will need to create Sorting and Groupings footer to
calclate to total for each group. Hope this helps.

-----Original Message-----
=DSum("[NOV2003]","History","[Contract] = 'Y'")

I'm creating a Report that is grouped by Contract...among

other groupings. I want to be able to sum the NOV2003
values only if Contract=Y, for each group. Using the
expression above gives me the total sum. How can I modify
it to give me the sum for each group?