|
|
|
About Sorting Records Before They're Retrieved from the Database 
There are two ways to sort records before they are retrieved from the database:
- Use a stored procedure with an ORDER BY clause in the SELECT statement. You can use the stored procedure by itself, or as the record source of a form, report, or data access page.
- Use an SQL statement with an ORDER BY clause in the RecordSource property of a form or report.
When you specify a sort order before records are retrieved from the database, you can perform both simple and complex sorts. Each time you view the results of a stored procedure or SQL statement, the sort order is automatically applied.
|
