I am taking this and grouping them - in the results if a value was missing it would be blank. But as soon as I add the summary of Group the blank turning into -None-. Any simple was to fix that?

I am taking this and grouping them - in the results if a value was missing it would be blank. But as soon as I add the summary of Group the blank turning into -None-. Any simple was to fix that?

Thanks Jack. Works great

It worked. Thanks

Thank you. I will give this a try and let you know. Thank you for the quick response.