How to Use Left, Right, Mid, Instr, and Trim in MS Access

20-July-2021
Knowing how to slice and dice your strings in MS Access is really important if you want to quickly dissect a string, or a bunch of field values. Some handy tools for this include the Left, Right, Mid, InStr, and Trim functions. These handy functions can be used as expressions in queries or on forms, but can also be used in VBA, making them essential for any data engineering work done in Access. They are a great set of tools for your toolkit!



MS Access Project? Contact me today!