I need a helping hand :I'm using access 2000 to manage a database I've created. When I type a name into the 'name' field (in form view) I want my database to insert a matching salutation automatically into the 'salutation' field - example
Mr J S Smith Mr Smith
Professor John Jones Professor Jones
Miss C Doe Miss Doe
I also want the option to amend this manually when a suffix is involved - eg
Dr J S Smith MD Dr MD corrected to Dr Smith
Mr Peter Jones QC Mr QC corrected to Mr Jones
I have no VBA or SQL skills so using the expression builder in access is not always straight forward for me. Can anyone write the necessary commands or show me how to do this? help
Mr J S Smith Mr Smith
Professor John Jones Professor Jones
Miss C Doe Miss Doe
I also want the option to amend this manually when a suffix is involved - eg
Dr J S Smith MD Dr MD corrected to Dr Smith
Mr Peter Jones QC Mr QC corrected to Mr Jones
I have no VBA or SQL skills so using the expression builder in access is not always straight forward for me. Can anyone write the necessary commands or show me how to do this? help