Counting Groups in a report with total in report footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete Rothery - 26 Feb 2007 20:57 GMT

I have put a text box called [Count] with control source [=1] in the group
header with running sum set to group. Then put text box called =[count] in
report footer.

It counts the groups nicely in the group header but the value in the report
footer is always 28!!!

I am stuck and would very much appreciate a bit of help

pete

Reply to this Message

Wayne-I-M - 26 Feb 2007 21:27 GMT

Hi Pete

Change the field name to something other than count. Set the control source
as

=Count([FieldName])

FieldName = the name of the field you are wanting to count.

Hope this helps

Signature

Wayne
Manchester, England.

> I have put a text box called [Count] with control source [=1] in the group
> header with running sum set to group. Then put text box called =[count] in
[quoted text clipped - 6 lines]
>
> pete

Reply to this Message

Pete Rothery - 26 Feb 2007 21:37 GMT

Hi Wayne
it worked straight away, i will worry bout where the 28 came from but not
for long!
Thanks a lot
Pete

> Hi Pete
>
[quoted text clipped - 17 lines]
> >
> > pete

Reply to this Message

Wayne-I-M - 26 Feb 2007 21:41 GMT

Maybe Mr Gates has come up with an access 2008 already and this counts the
coffees you have had today or the cards you got for christmas who knows

:-)

Glad it worked

Good luck with your project

Signature

Wayne
Manchester, England.

> Hi Wayne
> it worked straight away, i will worry bout where the 28 came from but not
[quoted text clipped - 23 lines]
> > >
> > > pete

Reply to this Message

Pat Hartman (MVP) - 26 Feb 2007 21:43 GMT

Count() always counts the rows in a domain. Try using the Sum() function.
It may give you the answer you want.

>I have put a text box called [Count] with control source [=1] in the group
> header with running sum set to group. Then put text box called =[count]
[quoted text clipped - 8 lines]
>
> pete

Reply to this Message