DSum by group

R

RussG

I have a textbox with a DSum function, but would like it to query only within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.

=DSum([MKTCAP],"QryFILTER",[MKTCAP]>100)

The text box is within the Group Footer, and I'd like it to return a
different value below each group.
Thanks!
 
T

Tom Lake

RussG said:
I have a textbox with a DSum function, but would like it to query only
within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.

=DSum([MKTCAP],"QryFILTER",[MKTCAP]>100)

The text box is within the Group Footer, and I'd like it to return a
different value below each group.
Thanks!
Click to expand...

The D in DSum stands for Domain. It will sum regardless of group.

In a group footer, you want Sum which will sum just that group.

Tom Lake
 
R

RussG

Is there a "sumif" function, or any other way to sum within a group based on
certain criteria?

Tom Lake said:
RussG said:
I have a textbox with a DSum function, but would like it to query only
within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.

=DSum([MKTCAP],"QryFILTER",[MKTCAP]>100)

The text box is within the Group Footer, and I'd like it to return a
different value below each group.
Thanks!
Click to expand...

The D in DSum stands for Domain. It will sum regardless of group.

In a group footer, you want Sum which will sum just that group.

Tom Lake
Click to expand...
 
Top