Hello i'm new here~
I'm using access 2002. I have a table database with multiple columns (one column is used for street names, and another for street numbers). I would like to organize in a way so that the street names are in alphabetical order, and the street numbers in the other column are organized numerically in respect to the street names.
This is how I would like to have it (example)
st_no | st_name
----------------------
153 | Abram
250 | Abram
12 | Kingston
31 | Kingston
53 | Kingston
659 | Lacy
(the street names in alphabetical order, and the street numbers in numerical order in respect to the street names.)
I don't know how to do it correctly. i tried advanced filter/sort (whatever that is) but no success. please help! thanks! :D
I'm using access 2002. I have a table database with multiple columns (one column is used for street names, and another for street numbers). I would like to organize in a way so that the street names are in alphabetical order, and the street numbers in the other column are organized numerically in respect to the street names.
This is how I would like to have it (example)
st_no | st_name
----------------------
153 | Abram
250 | Abram
12 | Kingston
31 | Kingston
53 | Kingston
659 | Lacy
(the street names in alphabetical order, and the street numbers in numerical order in respect to the street names.)
I don't know how to do it correctly. i tried advanced filter/sort (whatever that is) but no success. please help! thanks! :D
