Can I create a "Sum" on an expression that is "Counting" in query?

[Guest]

Okay, lets see if I can explain this.....

I have a table that contains information on lets say paint colors. So the
information in the table would something like this:

date sold color sold by
6-14-06 cotton candy j. doe
5-30-06 sky blue j. smith
etc.

Of course there would be multiple entries of the same color w/ multiple
entries for seller.

I would then want to run a report by seller with a total for each color and
then a total of all colors sold by employee.

In my query, the color field is a text, so I cannot put in "sum" in the
"total" box. An expression (Expr 1) has been created to "count" the colors
that were inputed in the table.

So when i pull up the report it looks like this

j. smith
red 2
cotton candy 3
sky blue 1
grass green 4

Now the problem comes in when i want to do a total of all the colors that j.
smith sold. I cannot get a sum to work. I have tried "=SumofExpr1" but when
running the report, it then asks for the above "=SumofExpr1" as a parameter.

I am assuming it is doing this b/c i can't mark "sum" in the total box for
the expression b/c "expression" is marked.

Does that make sense? If so, I'd love to hear how I can make this work.

 

[Jeff L]

Try this instead. It looks like you have a header for the name with
the detail below it. Put a textbox in the footer of the name with
=Sum(Expr1) in it. That should give you the total.