How can I set up a custom sort order,Access reports ie. S,M,L,XL

[Lou]

I would like to sort a report instead of Alphabetically, I would like to sort
the field by Small, Medium, Large, XLarge, Currently they sort
alphabetically, Large, Medium, Small, Xlarge. Which is out of order in the
Fashion business. Thanks for anyhelp on this

 

[John Spencer]

Set up an auxiliary table with two columns
TheSize: Small, Medium, Large, XLarge
SizeSortOrder: Number field (1, 2, 3, 4)

Include that table in your query and use the SizeSortOrder field to do the
sorting.

Or you could use a kludge and sort by an expression such as
=Instr(1,"Small Medium Large XLarge",[SizeField])
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..