ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you Anders Ebro. That worked for just fine. I am embarassed to ask such a simple question. I found an answer in my wife's Alison Balter book that looked good, but yours was more complete and specific to my situation. I am a bit behind on this project so getting a quick answer was most helpful to me. Thank you.
If its any comfort, switching back and forth between T-SQL and vba, I probably by accident (or because I am forgetfull) use the T-SQL syntax at least once a month, and then scratch my head until I remember my mistake.