How do I separate data in address field?

G

Guest

I have over 1,000 records in an address data base. The street address field
contains both the house number and the street name. I need to place these in
separate fields so that I can sort by street name. Is there a shortcut to
doing this so that I don’t have to cut and paste each individual record?
Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I separate data in address field? 1
Split data in field on character return 0
Special characters 3
split address field 1
Picking specific records from a table 1
Merging address cells 1
Stripping city from address field and placing into city field 3
how do i separate an address field into three fields Access 2007 7

Top