AnsweredAssumed Answered

How can I count related data with a special parameter?

Question asked by on Apr 6, 2017
Latest reply on Apr 6, 2017 by taylorsharpe


I have a quite simple database with companies, contacts and materials per contact. Now I want to show the number of a special types of materials in a list of companies for each company. Among materials we have "photo" or "document". Each material recordset has a field "type".


I tried something like a sum together with an if-clause but it always counts all related material recordset if at least one of it had the right type or nothing.


Any ideas?