Count on Report (1 Viewer)

[cktcPeterson]

I have a query with 2 tables.
Requested Course and the Status of the course

When I run the report it shows perfectly,
Only list the Provider and the Courses they offer are listed perfectly

When I go to do the count. I only want the count of each course. Right now it includes the count for everyone who was in it. I do have a unique value set. I think my issue is that I have 2 tables, but I need the status in there cause I have criteria.

Example:
Martial Arts has 8 classes

I want my report to say 8. Currently, it says 20 because that many kids took those 8 classes.

 

[GinaWhipp]

Do you have the report grouped by Courses? Then you could do a count over the group.

 

[cktcPeterson]

I do have it group. Then when I select the group at the bottom and totals still gives me the total students who attend each course.

 

[GinaWhipp]

How are you counting?

 

[arnelgp]

On design view of your Report, Click on your "counting textbox".
on the Property Sheet->Data->Running Sum = No.

 

[Pat Hartman]

When I run the report it shows perfectly,
Only list the Provider and the Courses they offer are listed perfectly

If you are trying to show only courses, do not include the student table.