I have a report on access that has a header group on part id so that it will total the quantity if there is more than one of the same part. I also have some parts that don't have a part id and they only show in the detail section. I have the detail section set for not visible because at first we thought there would only be parts with part ids but now there isn't. So what I want to be able to do is hide the header group if there is no part id and show only the detail section but if there are part ids then show the header group.
Now the real problem is what is going to happen when I have a report that has part ids on some and not on others. I hope this makes sense.