Sort by multiple fields

  • Thread starter Thread starter Neal
  • Start date Start date
N

Neal

Hi,

Is there a way to sort an Access table or query by
multiple fields (similar to Excel). For example sort by
first field, then sort that by another field?

Thanks,

Neal
 
Here is a simple SQL example

SELECT tbl_Customers.Name, tbl_Customers.Address, tbl_Customers.Town,
tbl_Customers.PostCode
FROM tbl_Customers
ORDER BY tbl_Customers.Name, tbl_Customers.Address, tbl_Customers.Town DESC;


the default order is Ascending to order decending add 'DESC' after the field
name as shown above
hope this helps

Dave
 
Back
Top