Sorting information

[Guest]

I have a paper route that is in an Excel worksheet. I've imported it into
access. I need to separate the route into two sets of streets. There are
about 20 street names. How do I do that? Thank you!!!!!

 

[John Vinson]

I have a paper route that is in an Excel worksheet. I've imported it into
access. I need to separate the route into two sets of streets. There are
about 20 street names. How do I do that? Thank you!!!!!

First off - jargon alert: "Sort" doesn't mean what you're using it to
mean. "Sort", in database terms, means "take a set of records and
display them in a particular order", as in sort the records
alphabetically by street name.

You would do this with a Query, but I have no clue how you are
defining the "sets" of streets, nor how the street is stored in your
table. Could you give a description of the fieldnames and datatypes in
your table, and give a couple of examples of a street? and - more
particularly - indicate what constitutes a "set" of streets?

John W. Vinson[MVP]