Forum Discussion

MarcMarc's avatar
MarcMarc
Qrew Trainee
6 years ago

Summary Report with zero assessments

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.

1 Reply

  • 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