Extract From 1 Field And Populate A Whole Lot Of Others..

I have read some tutorials online on how to split data into multiple fields.

http://www.databasedev.co.uk/splitting_fields.html

While this is the gist of what I need - it is much more complex.

I am dealing with adresses.

This inherited database has 2 fields - ZIP, and ADDRESS. I need to extract the data within the ADDRESS field to populate other more detailed named fields.

I would like to ultimately have my fileds to be: STREETNUM, STPREDIR, STREETNAME, STREETSUFX, SUD, SNUM.

Example: (Current ADDRESS data)

512 N Manchester Dr Ste 201

(extract ADDRESS and import into)

STREETNUM = 512
STPREDIR = N
STREETNAME = Manchester
STREETSUFX = Dr
SUD = Ste
SNUM = 201

--

Now I have tried several queries to extract the first bit of data 'STREETNUM', using the example on the link I posted above. INSTR, RIGHT, MID, LEFT.

Problem is there are also P.O. Boxes formatted like: PO BOX 1234, so my STREETNUM column includes the PO, when it should include the 1234.

PO Box 1234 should translate to:

STREETNUM = 1234
STREETNAME = PO BOX

All the rest of the fields aren't needed.

As you can see, I'm in OVER my head.

I would greatly appreciate any assistance or direction in accomplishing this task.

I am not a beginner with Access, but I am far from being an expert. A breakdown of some complicated tasks may be necessary... :-)

Thanks in advanced.