I am trying to insert the following into a query on one line with "or" in between. The code works but when I run it, "Like '3' appears on one line and Is Null appears below it. Is there a way I can pass this to the query so it shows, Like '3' or Is Null on one line? Hope this makes sense. Thanks!
strCriteria5 = "SalesbyRSM3.Relay_Rep Like '3'" & " OR SalesbyRSM3.Relay_Rep Is Null "
strCriteria5 = "SalesbyRSM3.Relay_Rep Like '3'" & " OR SalesbyRSM3.Relay_Rep Is Null "