Thanks MtDew, that helped me out! I guess I really should go and study on my inner joins.<BR><BR>MrMills: No worry for any injection vulnerabilities. Trust me.

Thanks Richard that got me on the right track, from there it was easier to see where the parenthesis needed to go since Access shreds mysql Here's the correct syntax for any search engine goers ...