User error!! The use of the "Join" function did fix the problem. When I tested previously, I copied my test code form this thread which had the query data changed from my production values and I failed to truly look at the result when it failed. Sorry.

Thanks for the solution. One that I should have been able to find.
_________________________
Home page: http://www.kixhelp.com/hb/