It shows like this.
Like '3'
Is Null
One beneath the other.
I want it to show as
Like '3' or Is Null (on one line in the Access query) with OR separating the two criteria's
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...
I keep playing around with this code and keep getting an error message "Type Mismatch" when trying to run the query. The code error is on the line after 'Else'. Does anyone know how this needs to be modified? Thanks
If Me!lstRRep.ItemsSelected.Count > 0 Then
For Each varItem In...