Need to sort several different fields together - Alphabetically

  • Thread starter Thread starter Jannette
  • Start date Start date
J

Jannette

I have to sort by last name, then first name, and by company (because some
businesses don't have a person assigned to them).

How can I achieve this!! Need help as soon as possbile.
 
Use an ORDER BY clause:

ORDER BY LastNameField, FirstNameField, CompanyNameField
 
Or if you mean you want to sort by Last Name and First Name, but if there is
no Last Name then you want to sort by company name.

ORDER BY NZ(LastName,CompanyName), FirstName, CompanyName


In the query design view, you would need to insert a calculated field before
the Firstname field
Field: SortThis: Nz(LastName,CompanyName)
Show: Not Checked
Sort: Ascending

Another way to handle this might be
Field: SortThis: Nz(LastName & FirstName & CompanyName)
Show: Not Checked
Sort: Ascending

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top