Need to place count value in report

J

Jaded in Cali

In an education report, I am listing results on a survey by section of a
course that have responded. I also need to show the total number of sections
in the course. I tried using
=Count(IIf(tables!tblSections!Course_ID = [Course_ID],[Section_ID]))

but I get parameter requests for both tables!tblSections!Course_ID and
[Course_ID].

Is there another way I can create a summary query to count the sections of a
course based on the couse number in the Detail section of the report?
 

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

Count query in report field 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Macro to count words in a section, excluding footnotes and end notes 1
How to count the numbers in a Word document? 0
HELP: Compare Column values with column names in different tables 5
Auto-Numbering in a Table in MS Word 1
Apply filter based on the value of a field 2
A03 - count in report footer gives me #Error? 0

Top