Invalid Syntax error - Access 365 - Update to the Issue

[Isaac]

Is Null is for queries; IsNull is a vba function. Try Is Null instead.

Hmm. IsNull in queries works for me, and Microsoft says it should be OK.
?

 

[Deleted member 147267]

Yeah, I should have paid more attention to the fact that this about an expression and not a Where clause.

 

[Deleted member 147267]

Maybe post the problem db itself? Then it might be able to be tested by various versions.