To permanently change the sort order.
-- Open the report in design view
-- Select View: Sorting and Grouping
-- In the dialog box, set up the new sort order.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County