I am working on a complicated report that I can't seem to crack. I have an Inventory table that holds IDs and codes associated with the IDs. Each ID can have more than one code, but will only be in the table if they have at least one. My report lists all the codes across the top and needs to print only the IDs that have at least one code missing. The word "Missing" prints in the column for any code that is missing for that ID. I am OK up to this point. The IDs are divided into numbered groups. There is another table that holds group numbers and IDs that meet a certain condition. There may be some IDs in a group that don't meet the condition, even if the group does. I need to suppress any IDs that are not in Table 2 if the group number is in Table 2. So if the group number does not appear in Table 2 then I print all IDs in that group, but if the group number does appear in Table 2 then I only print IDs that are also in Table 2. I have tried using formulas and variables, but I can't make it work. I would appreciate any suggestions. Thanks.

I would be interested to know how you go about getting the data; are you running a query against a database or trying to sort everything out inside the report?  Do you have a Table that contains just the codes and perhaps a description?