One field - Address. It contains the street address and the PO Box address. I want to extract the data starting with "PO Box" and the information to the right of it. Any suggestions?

Hi,

Can you give us an example of the data in the field 'Address'?

32 E Market St PO Box 72

I want only the information starting with PO Box and what ever follows.

You can use InStr to find the phrase PO Box:

In a query,

P: InStr(1, [FieldName], "PO Box")

P1: Mid$([FieldName], P)

P will be the position where PO Box starts
P1 then will be the portion of the original field that begins with PO Box

OK- you are to advanced for me - when I put this in the query I receive an error.
Instr(1,[Address],"PO Box")Mid$([Address],P)

Each belongs in its own Field: cell in the query.

That fixed the problem. Thank You!

Won't that run into issues if there's a P in the address, as in:

1234 Davis Place PO Box 1234

??

You're welcome. I am glad I could help.

No, I am finding PO Box---the entire phrase, not just the P.

Right, sorry. I hit super-dyslexia on that one.

No problem, thanks for checking me---I do make mistakes from time to time, more often than I will admit in public.