Sort order

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

Hi. Is it possible to sort on two different fields? I
have State as the main sort, but I'd also like City to
sort within the State. Can it be done and how would I do
it?

Thanks,
Stephanie
 
This was just answered a few hours ago. Did you try searching for similar
posts?

A query will search based on the "Sort" field. If you want to sort by more
than one, put your primary sort field in your query and select ascending or
descending. Then, put your secondary sort in the query (to the right of
your primary sort) and set the Sort order.

If you wnat the results to display City, State, Zip, in that order, but you
want to sort by state first, you can create a new column in your query with
the STATE sorted, ant then another column with the CITY. Uncheck the "Show"
field so these columns are hidden and only used for the purpose of sorting.

Please search for answers before postng a new thread.
 
The previous post I mentioned is from 10:09 AM today and has a subject of, "
sort on multiple fields in an Access query"





Rick B
 
Thanks for the help. Stephanie
-----Original Message-----
ORDER BY [State], [City]

--

Ken Snell
<MS ACCESS MVP>

Hi. Is it possible to sort on two different fields? I
have State as the main sort, but I'd also like City to
sort within the State. Can it be done and how would I do
it?

Thanks,
Stephanie
Click to expand...


.
Click to expand...
 
Back
Top