count of group with out groupby

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Imran J Khan - 28 May 2008 20:06 GMT

In a report I am trying to get a count of each group in a field, without
using groupby in a query builder. I trying to creat an experession in control
source property of a control in the report. Using the count function, I get
the total count for that field. I need to be able to count each group,i.e
each anwser in that field.
Currently I have four records, 14,8,11,16, so the count will only be 1.
Thanks
Imran

Reply to this Message

Klatuu - 28 May 2008 21:26 GMT

use the report's sorting and grouping. You can then create a footer for the
group and do the Count there. It will only Count across the group.

Signature

Dave Hargis, Microsoft Access MVP

> In a report I am trying to get a count of each group in a field, without
> using groupby in a query builder. I trying to creat an experession in control
[quoted text clipped - 4 lines]
> Thanks
> Imran

Reply to this Message

Imran J Khan - 28 May 2008 22:57 GMT

Thanks, that worked so far.

> use the report's sorting and grouping. You can then create a footer for the
> group and do the Count there. It will only Count across the group.
[quoted text clipped - 7 lines]
> > Thanks
> > Imran

Reply to this Message