| | |
|
|
|
Query sorting |
|---|
| message from =?Utf-8?B?Tmlja2lvcw==?= on 23 May 2004 |
I have a query that outputs the following columns in left to right order: Paitent number, sex, postcode, admission date, discharge date, admission method code, discharge code and daignosis. How can i sort the data retrieved by the query by disharge date and then by admission date (remebering that the admission date is the cloumn left of the discharge date)?
|
| RobFMS replied to =?Utf-8?B?Tmlja2lvcw==?= on 23 May 2004 |
SELECT ...
FROM ...
ORDER BY [Discharge Date], [Admission Date]
When you look at the query in Design view, you will see how it is designed.
HTH
|
|
Archived message: Query sorting (Microsoft Access Error Message)
