Apostrophes in names can play havoc with your design so there's that. One way around it would be to simply remove them with an update query. If you still need to see them in some sort of output, then having a display field (O'Brien) and a search field (OBrien) would allow you to work with the data but still display it as it really is.
Then there's the problem of searching on text using Between. That seems like you have no numeric index such as an autonumber primary field. You should be using Between on numbers, not text, like Between 2 and 4
CompanyIDpk |
CompanyName |
1 |
ACME |
2 |
Widgets Inc. |
3 |
Amazon |
4 |
Best Buy |
Last edited by Micron; 01-04-2022 at 10:32 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.