Invalid Syntax error - Access 365 - Update to the Issue

[Deleted member 147267]

When I switch to SQL code and have the correct syntax (which I didn't in the post I deleted), I do not get an error.

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

 

[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.
?

 

[Uncle Gizmo]

What version of Access are you using?

2016 64bit

 

[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.