Use String Functions to Validate Part Numbers in Microsoft Access: Left, Right, Mid, Len, InStr

About this tutorial:

Video duration: 00:17:55
In this video I will teach you how to use the string functions in Microsoft Access to make sure users are entering valid part numbers according to a set of rules. We will learn about the Left, Right, Mid, Len, and InStr functions.

Zoe from Great Falls, Montana (a Platinum Member) asks: When placing an order with our primary supplier, we have to make sure the part number is valid. They have a gigantic database of parts, and it changes constantly, so looking up each part number isn’t practical. They do, however have a specific format for all of their part numbers. If I could just make sure…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads