>>If you remove the GROUP BY, does the missing item show up?
>
>Yes, The item does show up (seven times).
Then it must be the GROUP BY that's the culprit...
Did you say somewhere else that "Select Distinct Item..." instead of GROUP BY didn't work also, or have you tried that?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.