I know this should not be difficult, but just
how can you use queries to "break up" field information. If say you have data like "220 Drury Lane" and you want to make that into separate fields, one for the number and one for the street, what is the easiest way to go about that? Much thanks to anyone who can help -

This Knowledge Base article will get you started...

http://support.microsoft.com/support/kb/articles/Q115/9/15.asp?LN=EN-US&SD=gn&FR=0&qry=q115915&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

John

I also found this article helped me out with performing the same type of actions.
http://www.access-programmers.co.uk/ubb/Forum1/HTML/002769.html