Sorting problem

[klr397]

I have a table with two columns

skill and category

i need to write some type of query or report that will group the skills into the numerical categories 1-9 and then in each of those groups listthe skills autamaticall and then have a way to print it out either in word or excel looking some thing like this

category 1
askill
bskill
cskill
category 2
askill
bskill
cskill
.....
any ideas?

 

[The_Doc_Man]

In the query design grid, put the category left-most, skill next to it.
Then in the SORT row of the grid, select either ascending or descending as appropriate for each field. Then save the query.