I'm using Access 2000 to manage a database.
My objective is simply :-
To convert one text format into another - where the program will simply select the first word
and last word in a name field and insert it into a salutation field on data entry.
Example:
aa bb ccccc - becomes aa ccccc
Mr J Doe - becomes Mr Doe
I'm a novice at writing code or using the built-in expressions etc in Access to write a coherent code/expression which works. Can anyone help - perhaps write a code which achieves this?
Thanks
My objective is simply :-
To convert one text format into another - where the program will simply select the first word
and last word in a name field and insert it into a salutation field on data entry.
Example:
aa bb ccccc - becomes aa ccccc
Mr J Doe - becomes Mr Doe
I'm a novice at writing code or using the built-in expressions etc in Access to write a coherent code/expression which works. Can anyone help - perhaps write a code which achieves this?
Thanks