Multi-Level sorting in a query 1

[drichter12]

Does Access (2007) allow multi-level sorting of results in a query?

I have a query that returns invoice data for a specific site. This data can span several months and several accounts within each of those months. I would like to be able to sort first on the invoice dates (which will always be the last day of the month) and then by the account (of which there are up to 4). The invoice date field is formatted as date/time, the account field is formatted as text if that is important.

Thanks,

Dale

 

[PHV]

SELECT ...
FROM ...
WHERE ...
ORDER BY [invoice date], [account]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[drichter12]

Thanks again...


Dale