update query, newbie

[ad602000]

I have a field called "given name", now in this field there are some people
who have two given names. Can anybody help me with an expression to use in
an update query that will delete the second given name? the names are
separated with a space

Many thanks
Peter

 

[danvlas]

Update TableName Set [Given Name] = LTrim(Left([Given Name], Instr([Given Name], " &quot)) Where InStr([Given Name], " &quot>0;

It should work.

Dan

 

[scriverb]

This should do it. Just change the name of the table(Table1) to your tablename.

UPDATE Table1 SET Table1.[Given Name] = Mid$([Table1]![Given Name],1,InStr(1,[Table1]![Given Name]," &quot-1);


Let me know how this works.
Bob Scriver

 

[danvlas]

Bob, if there is no space in the string, Peter will have a hard time retyping the names...

Regards,

Dan