(Solved) – where clause in VBA doesn’t return what I need

  • by
(solved)-–-where-clause-in-vba-doesn’t-return-what-i-need

I am trying to filter a dataset that I am pulling in from access using VBA, but for some reason this code doesn’t return the filtered results.

  With BrokerData
        .ActiveConnection = BrokerConn
        .Source = "SELECT * FROM BP_Closed_Deals WHERE EMM_Name = 'JM' OR 'J-C E';"
        .LockType = adLockReadOnly
        .CursorType = adOpenForwardOnly
        .Open
    End With

Leave a Reply

Your email address will not be published. Required fields are marked *