Рет қаралды 4,640
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 KZbins can be found at: learncs.w3spac...