Robin,
Is this for permanent or on the fly calculation? Does every record have two names with a "/" between them? Are there any spaces to worry about?
What have you tried? There are lots of string functions that can help.
Instr() can be used to find the position of the "/"
Left() returns a specific number of characters beginning a string
Mid() returns a specific number of characters beginning at a location
Duane Hookom MVP
MS Access
Is this for permanent or on the fly calculation? Does every record have two names with a "/" between them? Are there any spaces to worry about?
What have you tried? There are lots of string functions that can help.
Instr() can be used to find the position of the "/"
Left() returns a specific number of characters beginning a string
Mid() returns a specific number of characters beginning at a location
Duane Hookom MVP
MS Access
> From: Robin Chapple
>
> I run Access 2013 on a Win7 system
>
> I have inherited a database with first names recorded as Mary/John in
> one field.
>
> How do I separate them into two fields?
>
> Many thanks,
>
> Robin Chapple
> I run Access 2013 on a Win7 system
>
> I have inherited a database with first names recorded as Mary/John in
> one field.
>
> How do I separate them into two fields?
>
> Many thanks,
>
> Robin Chapple
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar