DSum by group


G

Guest

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!
 
Ad

Advertisements

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!

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
 
Ad

Advertisements

G

Guest

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!

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top