access 2003

[Guest]

In a database for track and field, I have a field 'Category' for juniors,
intermediates, and seniors. In table view, I tried to use advanced filter to
sort the kids into juniors, intermediates, and seniors. But each time I get
intermediates first then juniors, and seniors as it is alphabetical order.

Is there a way to sort/filter so I can select the text that I want to order?
ie. I want to filter so juniors is selected first, then intermediates then
seniors.

 

[Arvin Meyer [MVP]]

You can add a custom sort field using an integer datatype in the Category
lookup table, then number the rows the way you want to sort them. Use a join
to add the sort field from the Category table to a query with the Category
ID of the field in your main data table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks for the help!

You can add a custom sort field using an integer datatype in the Category
lookup table, then number the rows the way you want to sort them. Use a join
to add the sort field from the Category table to a query with the Category
ID of the field in your main data table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access