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

How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA
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!
Related Videos:
How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA
You are watching this video now!
How to Use DateAdd, DateDiff, and DatePart to Calculate Dates in MS Access
• How to Use DateAdd, Da...
How to Handle Line Breaks in Microsoft Access
• How to Handle Line Bre...
How to Open a RecordSet in Access VBA and Loop Through the Records
• How to Open a RecordSe...
How to Use BOF and EOF on Recordsets in MS Access
• How to Use BOF and EOF...
How to use With.. End With in MS Access VBA
• How to use With.. End ...
How to Use Global Variables in Microsoft Access VBA
• How to Use Global Vari...
How to Use For Next Loops in MS Access VBA
• How to Use For Next Lo...
How to Use a Do While Loop in MS Access VBA
• How to Use a Do While ...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#MSAccessVBA
• How to Use Left, Right...

[@nickdavenport8541]

Hi, i watched your video trying to understand how to take a single field with text either side of a '\' symbol so the information can be split into two different fields as part of an update expression query in access. Do you have a similar video that touches on this topic?? - For example; Fullname field = John\Smith and i want to split it in an update query to a new field - 'First name' returning as 'John', and the second field 'Last name' returing from the query as 'Smith'. I need to be able to split by the left and right of the '\' symbol as the Char lenghts are never the same.

[@seanmackenziedataengineering]

Great question! Yes you can: kzbin.info/www/bejne/rIK7YaeXhbZ_eJI

[@aquariumfishes1584]

very good keep uploading

[@seanmackenziedataengineering]

Thank you, I will!