Invalid Syntax error - Access 365 - Update to the Issue (1 Viewer)

Micron

AWF VIP
Local time
Today, 14:10
Joined
Oct 20, 2018
Messages
3,476
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.
 

Micron

AWF VIP
Local time
Today, 14:10
Joined
Oct 20, 2018
Messages
3,476
Yeah, I should have paid more attention to the fact that this about an expression and not a Where clause.
 

Micron

AWF VIP
Local time
Today, 14:10
Joined
Oct 20, 2018
Messages
3,476
Maybe post the problem db itself? Then it might be able to be tested by various versions.
 

Users who are viewing this thread

Top Bottom