Need to search an address field to extract a house number (always first in the string if it exists), and the string "Apt" (which may or may not exist as well). Example:
Field1=1245 Main St Apt 6
results in
Field1=Main St
Field2=1245
Field3=Apt 6


Nice thing is...if Apt exists in the original field, it will always be at the end of the string so you can take everything from the A to the end of the string. Would love to do this in an update query if possible. Thx.