No Current Record in query (1 Viewer)

[sportsguy]

I have been using access for over twenty years, and I am stumped at this one.

I have a query with a table, with several FK fields, and a total,
two where clauses, and a sum >=25000
run the query, all is fine
I link a FK to an attribute1 description table with key field, equal join
run the query, all is fine
I link a FK to an attribute2 description table with key field, equal join
run the query, all is fine

I link a FK to an attribute3 description table with key field, LEFT join
and the FK field has some Null fields. . .

I add the description name of table 3 and all is fine
I add a boolean flag field, some true, some false,
fun the query and I get no current record. . .

when does this happen? Why does the query not recognize a boolean field with a left join?
sorry for the newbie question. . .

thanks in advance.

sportsguy

 

[NickHa]

I don't see enough detail here to answer your question

Can you post your query at the point where it works, then again with the Boolean fields added where it doesn't work?

My first thought was around the FK for table 3 which has some null values, but your subsequent text suggests that isn't the problem.