How do I set print order for report?

[Annabelle]

Is there a way to tell a subreport (printing on a report) to print in a particular order. FYI - it is being told to print in alphabetical order but there are a couple of the items we need to print at the top, then we want the rest to print in alphabetical order.

Can this be done?

 

[llkhoutx]

One way is to add a field to your recordsource which corresponds to the print order you want and is used as the sort key of your report recordsource.