Auto insert - Accessdatabase

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Mayzio

Thread Starter
Joined
Nov 15, 2002
Messages
20
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
 
Joined
Jul 29, 2001
Messages
21,334
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top