Auto insert - Accessdatabase

[Mayzio]

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

 

[Rockn]

Look up the MID function, I think it will do what you are looking for. Seems your tables are not written very well though. It's usually a good idea to seperate out first and last names into seperate fields in your table for the very reason you are looking at. It also makes indexing and searching records a lot smoother as well.