Trouble with Group Counts 3

[deweb]

I have designed a report for my trainings database which is based on a query. The report is grouped by Organizations, then trainings, then the attendees (from that Organization) are listed, something like this:

Organization 1
First Training
Last, First
Last, First
Last, First
Second Training
Last, First
Last, First
Organization 2
First Training
Last, First
Last, First
Third Training
Last, First


My problem is I can't figure out how to count the number of individual organizations that received training (regardless of the number of trainings or attendees), or the total number of trainings received by an individual organization (regardless of the number of attendees). Every count function I use in a group or report footer, (i.e. Count([TrainingID]) just gives me the total number of records in the group or the report.

Any suggestions?

Thanks.

 

[PaulBricker]

To get the total number of organization you can do this.

Add a textbox to the organization header. Set it's Control Source to =1, it's Running Sum property to Over All and it's Visible property to No. Then in the Report Footer add a textbox that has the Control Source set to =RunningSumTextboxName

This will return the last value in the running sum textbox which will be the same as a count.

To get the Total number of Training by an organization, you would do the same thing only put the running sum textbox in the Training Header and set it's Running Sum property to Over Group. Then put a textbox in the Training Group Footer with the control source set to =RunningSumTextboxName

That should do that. Post back if you have problems.

Paul

 

[dhookom]

Great answer Paul. Deserves a star.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[deweb]

Have another star! It works great.

Now, how do I get a "grand total" of the trainings into the report footer?

Thanks.

Denise

 

[PaulBricker]

Same way you got the Organization. Put a textbox in the Training header, set the control source to =1 and the Running sum property to Over All. Set the visible property to No. Then in the Report footer set the control source for a textbox to =TrainingRunningSumTextboxName


Paul

 

[deweb]

That makes sense. Thanks again.

Denise