Help Me

[RelapseWizard]

Initials____Forename
J y________ John Henry

Left([Forename],1)+" "+Right([Forename],1)

I'm processing a survey and trying to Update Initials field on a query and have used this query above but the update that comes up is as above, I am required to put both initials on the field can someone have a look to see if there is a way to pull both into the initial field. Thanks

 

[DCrake]

John Henry

What do you want? JH or J or JY

 

[namliam]

You will need a user defined function, to look for spaces then take the first character of the name...

 

[Atomic Shrimp]

Left([Forename],1)+Mid([Forename],InStr([Forename]," "),2)

 

[RelapseWizard]

Thanks a lot Mike

I've used this one as query1
Left([Forename],1)+Mid([Forename],InStr([Forename]," "),2)
for some reason it updates initials for everyone with a second name.

I used this as query2 Where initial is Null
Left([Forename],1)

It worked thanks very much.

 

[Atomic Shrimp]

No problem. In the longer term, you probably ought to consider storing only the forenames in the forename field and have another field to hold the surnames...

 

[namliam]

@Mike
This is a case where he is working with Second/Christian names, not last names... Considering the fieldname beeing "forename"

@RW
What if there are persons who have 3 names? Or 4?
You can (and should IMHO) make a UDF to extra just the initials you want regardsless of there beeing 1 or 10 names.

 

[DCrake]

It's a good job Tom Alphabet Pepper doesn't appear on his list.

 

[Atomic Shrimp]

@Mike
This is a case where he is working with Second/Christian names, not last names... Considering the fieldname beeing "forename"

Ah. Gotcha. I mistook (thinking 'Henry' was a surname) this for a case where people had been abusing the system by entering the full name into the forename field.