R
Roger Bell
Is there any way I can design an Update query or other query type to transfer
street numbers which form part af an address field: EG: 21 Smith Street to a
new field called Street Number and then Delete just the Street number from
the existing address field.
New fields would appear as: Street Number : 21; Street Name: Smith Street
Thanks for any help
street numbers which form part af an address field: EG: 21 Smith Street to a
new field called Street Number and then Delete just the Street number from
the existing address field.
New fields would appear as: Street Number : 21; Street Name: Smith Street
Thanks for any help