Skip to main content
Question

Summary report Count if absent

  • November 14, 2017
  • 0 replies
  • 11 views
I'm creating a summary report of consultant evaluations. I have two tables.
  • consultants
  • evaluations
I am trying to list any consultant that does not have any evaluations.

Ideas on how to accomplish this?

Thx.
Thank you, [FirstName] [Designation] [JobTitle] [CompanyName] [City] [State] [Phone]
    This topic has been closed for replies.

    If you have a Relationship where 1 Consultant has many Evaluations, edit that Relationships and on the right side add a Summary field to Count the # of Evaluations.

    Then just run a report of consultants with a filter of

    [# of Evaluations] = 0
    Terms & ConditionsAccessibility statement