Hello - I hope someone can help.
We have an Access 2007 database with many thousands of names and addresses, for a mailshot. The name field is a single field with the title, initials and surname in the one field. We need to create salutation fields using the title and surname only.
The added complication is that the names are different lengths.
E.g.
Ms J Lewis
Mrs P D G Jones-Green
So far I've tried using replace, I've tried trim too. Using Right([name],5) as an example only works for names of the appropriate length and I cannot find an easy way to categorise the lengths of name to run the query several times.
Is there code I can use that would select everything to the right of the last space ?
I'm sure lots of people must have to do this....
Please advise, thank you.
Kate
We have an Access 2007 database with many thousands of names and addresses, for a mailshot. The name field is a single field with the title, initials and surname in the one field. We need to create salutation fields using the title and surname only.
The added complication is that the names are different lengths.
E.g.
Ms J Lewis
Mrs P D G Jones-Green
So far I've tried using replace, I've tried trim too. Using Right([name],5) as an example only works for names of the appropriate length and I cannot find an easy way to categorise the lengths of name to run the query several times.
Is there code I can use that would select everything to the right of the last space ?
I'm sure lots of people must have to do this....
Please advise, thank you.
Kate