[AccessD] Numbers within a street

I am working on a political campaign management app. The thing I need to do
is post reports that identify the even and odd numbers on a given street. I
inherited the db and have freedom to change it (it was written by amateurs
and they know it and there are no hard feelings if I make a change, insofar
as said change increases productivity).

So... given a current field called StreetAddress, I want to break it into
two fields, StreetNumber and StreetAddress, so that I can filter the even
numbers for one report  and the odd numbers for an identical report. How can
I intelligently extract the data and populate my new columns?

Example data:

123 Normal Street ' easy
234A Abnormal Street ' a tad trickier
2333-1070 Queen Street  ' the 2333 part should fall into the StreetNumber
field and the rest into the StreetAddress field.

Any clever ideas how I might achieve this?

TIA,
Arthur