I have a report where there is a project number and a location among other fields. 97 percent of the time there will be one location per project number. So, I have them both in the header section of the Project Number. Now, in the case of the other 3 percent, when there is a second location it does not show. In order for it to show I would have to use the location Header section. But, this will produce a repeat for those that dont have separate values..

any suggestions?

Bob,

Create a special query field that combines the project number and the location number. Something like this: "127-444" where "127" is the project number, and "444" is the location number. Use THIS field as the group header, and I think you'll be fine.

Hope this helps,

Dennis

i will give it a try.

Thanks !

EDIT:

Perfect! Thanks Dennis