Then in the query you can join on the Gender or GenderCode to get the sort order. Add the Sort to your query and sort Ascending or Descending.
But it looks like the data is pretty much in Alpha order. Is the sorting in the query not working the way you want it to? You should just be able to put Ethnicity first and sort Ascending, followed by Gender and sort it Ascending etc.
If you are trying to do this in a report, the order in the query is ignored by the report. To order the data use the Sorting and Grouping option in the View menu. You will only see it when you have the report in Design View. Then just add Ethnicity, Gender, etc. and sort accordingly.
DC-I was messing around with it a bit at the end of last week. I got it semi-sorted, but as you pointed out, the order of the query is ignored by the report....so I think I'll just run the query and try to follow your suggestions about sorting and grouping within the report.
This seems to be the most logical way to work it.
Thanks for your input. As always, I appreciate the help!