Grouping Results

B

Brennan

I just added group footer to and a sum field to the data in the group. The
problem is that it will sum part of the group and then sum the other part. I
tried changing the "group on" property to Prefix characters and each value.
Group on prefixed characters groups all of the similarly named data points,
but leaves out those that don't follow the same name convention. Group on
Each value creates a sum behind each data point. What am I doing wrong?!?
Thanks for your help.

B
 
K

KARL DEWEY

Sounds like you need to add a calculated field to your query for the prefix
characters and group on that.
 

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