What do I use to complete Wildcards searches connected to Access database via VB.Net frontend in the Query Builder in VB.NET.
I have tried = ? in the FILTER column in the Query Builder, this make you type in the full string in the search field. My SQL looks like this:
SELECT CARRIERID, ACCOUNTID, MEMBERID, MBRLSTNME, MBRFSTNME, RXNUMBER, DTEFILLED, RBLDUEAMT, CHECK_NUMBER, CHECK_DATE,
WHERE (CHECK_NUMBER = ?)