Counting Groups in a report with total in report footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Hi Wayne
it worked straight away, i will worry bout where the 28 came from but not
for long!
Thanks a lot
Pete

Wayne-I-M said:
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.



Pete Rothery said:
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
 
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.



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

Wayne-I-M said:
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.



Pete Rothery said:
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
 
Count() always counts the rows in a domain. Try using the Sum() function.
It may give you the answer you want.
 

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

Back
Top