Summary Report with zero assessments

Question

I'm trying to create a summary report of consultant assessments. I have two tables.

consultants
assessments

I am trying to list any consultant that does not have any assessment.

Ideas on how to accomplish this?

Thx.

AlexGale · Answer

I'm assuming you have a one-many relationship here, with Consultants having many Assessments.

It sounds like what you want is a summary field, which you can then use to filter a regular report. You can set up a summary field called # of Assessments on the consultants table to count all related assessments. Then, you can simply filter any report to only include consultants where # of assessments = 0

Sign up

Login to the community