Microsoft Access A to Z: Breaking the first and last name out of a single field
This short screencast will examine the common relational database problem of entering the first, middle, and last names into a single field which makes it difficult to sort by last name or select only part of a name for a letter, email, or report. This screencast will show how to use an Access query to separate the pieces of a string by using calculated fields to separate out the parts of a field using Access built-in functions such as InStr(), Iif(), Len(), Left(), and Right()
All of my YouTubes can be found at: https://learncs.w3spaces.com/
