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

G

Guest

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
 
J

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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to control order of crosstab results 1
Custom Sort Order in a Form 2
Sorting for report presentation - can I set a specific order? 1
Custom Sort 1
How can I sort an access report by an avg value in a footer? 2
Custom sort order 3
How do I sort a sum value for a group of records in an Access rep. 2
How to set the sort order of a report from a query 2

Top