Ok, I've been looking at it that db and I'm trying to understand the query, basically what your db does is that when the checkbox is checked yes, the word yes appears in the next column and vice versa for "no". I'm not completely familiar with the
MyNewFld: IIf([blnYesNo],"Yes","No")
and what...