Report, grouped, to total number of records in that group?

  • Thread starter Thread starter Guest
  • Start date Start date
In the group's footer or header, place a textbox with this as controlsource:
Count(someFieldInSection)

Barry
 
Do i need to use a formula of any sort?

Barry Gilbert said:
In the group's footer or header, place a textbox with this as controlsource:
Count(someFieldInSection)

Barry
Click to expand...
 
hornywithab said:
Please get back if need more info!
Click to expand...


Please explain what you are trying to accomplish in more
detail.

If all you want is to total a the values in a field in the
detail section, then use a text box (in the group footer
section) with an expression like =Sum([name of field])
 
I think Barry meant...
= Count(somefield)
The equal sign makes the text control an unbound calculated field.
 
You must log in or register to reply here.

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

Similar Threads

Group Totals and Grand Totals on each page 3
Count total number of groups in report 4
Suppress total for first record of a group 1
Total different groups 4
How to "copy" group running total to report footer? 3
Count or sum unique records in a report's group footer in Access 2 2
Count In Group Footer 1
report data grouping failure? 4

Back
Top