Yes, I'm Bill. Show me your updated code.
Have you debugged by trying the query directly in Access? Sometimes Access will give you a better message than the JET engine will.
Also, show me which line you are getting the error from, just in case.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.