Search results

  1. J

    Problem with OR in SQL statement

    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
  2. J

    Problem with OR in SQL statement

    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...
  3. J

    Type Mismatch

    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...
Back
Top Bottom