Counting Contacts with Null Values Mix

  • Thread starter Thread starter T'myra
  • Start date Start date
T

T'myra

I need to create a report that summarizes the amount of
sessions each student receives (based off a daily service
log). I have a check box in the daily log table that the
teachers check off if this is considered towards a session
limit. I can get the report to count all of the checked
boxes per student. The problem is, some of the students
are newly registered and have not been seen yet, therefore
they have no entries whatsover in the daily log. These
students do not appear on the caseload report. I need to
pull up a report that lists all the students with the
number of sessions EVEN IF ZERRO. Please help, I am so
frustrated and really need to build this report.
 
T'myra said:
I need to create a report that summarizes the amount of
sessions each student receives (based off a daily service
log). I have a check box in the daily log table that the
teachers check off if this is considered towards a session
limit. I can get the report to count all of the checked
boxes per student. The problem is, some of the students
are newly registered and have not been seen yet, therefore
they have no entries whatsover in the daily log. These
students do not appear on the caseload report. I need to
pull up a report that lists all the students with the
number of sessions EVEN IF ZERRO.
Click to expand...


Check the report's record source query. Does it have at
least one record for each student? It sounds like the
report is based on the sessions table, which doesn't have a
record until a student attends a session. If so, you need
to construct a query that includes the students table and
the sessions table joined on the student ID field. Make
sure the join type is set so it includes all records in the
students table and any matching records from the sessions
table.
 
Back
Top