Try a SWITCH statement - Jet Driver doesn't support CASE/IF.
Look at the last post on this for an example: The statement could not be parsed. (SQL Server Import and Export Wizard)
Hope this helps!
You hit that one right on the nail. "Switch" Works perfectly fine.
Thanks so much for the suggestion!