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.