No Current Record in Microsoft (MS) Access Query

I just battled this for two days before finding an answer so I want to post it. I recently was getting a "No Current Record" error in my MS Access query when I tried to include a Yes/No field and use a left join.

I finally figured out why: Access forces the field to be 0 or -1 (in my case) and does not allow nulls. When you have a left join you can get nulls. The solution was to convert the Y/N to text and then do the comparison.

In your Query, just build it like this:

ucase([Y/N Field Name])

this makes it a nullable text field instead of a Y/N.

Good luck!