Main Report Footer from Sub Report

[Teri Bridges]

I am looking to get the event count from my event report ininto the Module and report footer.

I need the report to show how many events there are by Module and then overall (by report). I tried to write the following, but of course I did not do well.

I do have an event Count Qry, but I could not figure out how to bring the count into the report. I have not had any luck searching online. Can anyone point me in the right direction?

 

[Teri Bridges]

Repeat the calculation in the report's footer.

Pat, I have tried that. The event report is my third nested sub-report. What appears to be happening is if there is no event for the lesson the event is showing up as a blank record and that blank record is being counted. It is like it is keeping a placeholder. I cannot figure how to get it not to show or count the blank record.

 

[Teri Bridges]

Pat, I have tried that. The event report is my third nested sub-report. What appears to be happening is if there is no event for the lesson the event is showing up as a blank record and that blank record is being counted. It is like it is keeping a placeholder. I cannot figure how to get it not to show or count the blank record.

OK I am going to back up. I am going to start with the very first report before I start nesting.

My Main report is going to list the courses by Module. When I get the report counting correctly my goal is to put in a prompt that requires the user to put in a catalog ID to filter the report to a specific course.

 

[Teri Bridges]

Is there a way to tell the report if the CourseID is blank don't count the record?

 

[Teri Bridges]

I read an article that said I could put a query in my report footer to get the count accurate. Is this a good practice?