Need to sort several different fields together - Alphabetically

[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.

 

[Ken Snell \(MVP\)]

Use an ORDER BY clause:

ORDER BY LastNameField, FirstNameField, CompanyNameField

 

[John Spencer]

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
..

 

[Jannette]

John - this is exactly what I was looking for! Many, many thanks!!!