My report shows test results for a laboratory, grouped into sample number so that each group may include results for several tests. If none of these tests are accredited then the accreditation logo shouldn't be shown. If all tests are accredited then the logo should be shown. This works as I've added linked the logo to the field indicating 'accredited' or 'not accredited' through the query.
However, if at least one of the tests is accredited then I need the logo to be shown, and this bit isn't working. I've run a few examples through and it seems to work where there is a logo first and last, even if records in between do not include the logo, but if the record with no logo is first or last then the logo isn't shown, even though it's there on other records in the group. I really hope this makes sense!! Can anyone suggest a way to make sure the logo appears if at least one record includes it? I've tried everything I can think of but hit dead end.
Thanks
Angie