Counting Groups in a report with total in report footer

[Guest]

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

 

[Guest]

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

 

[Guest]

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

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

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

 

[Guest]

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

--
Wayne
Manchester, England.

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

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

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

 

[Pat Hartman \(MVP\)]

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