Transfer records in a field to another field

[Curaçaoboy]

Hi ,
It is me again.
I have a database with names and addresses. I didn’t created, because then I would take consideration with the following problem.

So I have a table like this :
Name Address 1 Address 2

Ana Smith P.O. Box 12233333 Adjfndkfndflknfl
Frank Boy Kakskskssk Dssdsdsdsdsd
Test sdsddefrtbg sasasasfrgb
George Nathan P.O. Box 12334455 tgtghjyjukik

Is there a way that in a query OR report I can create a new field and then come up with the following result:

Name Address 1 Address 2 P.O.Box
Ana Smith ----- Adjfndkfndflknfl P.O. Box 12233333
Frank Boy Kakskskssk Dssdsdsdsdsd -----
Test sdsddefrtbg sasasasfrgb ----
George Nathan ------- tgtghjyjukik P.O. Box 12334455


So in other words, I what to create for all P.O. box a separate field.

Is there a way to do this ??

 

[aleb]

You want to extract the PO box information from a certain field and then place into another field?

 

[amolin]

Please try this:

 

[aleb]

Is this what you wanted ?