Using Expressions to Work with Strings of Text in Access 97/2000 
In Microsoft Access, you can use expressions to work with strings of text. You can combine two or more text strings into a single text string. These expressions are commonly used in controls on forms and reports.
Also, you can use string manipulation functions in an expression to manipulate text. For example, you can use these functions to separate a text string into two strings. Expressions that extract a portion of a text string are commonly used in update queries.
