sort two fields

[Guest]

I am new to access. I am working with employee names and their assignments.
How can I alphabetize the names within the work assignments?
Example:

John Doe- Baltimore
Jane Doe- Baltimore
Hank Smith- Baltimore
Abe Johnson- Tulsa
Amy Brown- Tulsa

How do I alphabetize the names within each city?????

 

[Arvin Meyer [MVP]]

Select Fullname, City
From MyTable
Order By City, Fullname;

 

[John W. Vinson]

I am new to access. I am working with employee names and their assignments.
How can I alphabetize the names within the work assignments?
Example:

John Doe- Baltimore
Jane Doe- Baltimore
Hank Smith- Baltimore
Abe Johnson- Tulsa
Amy Brown- Tulsa

How do I alphabetize the names within each city?????

Create a Query based on the table; put the city name first, to the left of the
employee name. Sort by each field (it handles them left to right).

Base a Form on the query if you want to see names to the left of the city -
query datasheets aren't intended for data interaction, use forms.

Note that you should have the names stored in two fields (at the very least),
FirstName and LastName. At some point you'll be asked to give a list
alphabetical by last name, which will be a major pain if you have them in one
field.

John W. Vinson [MVP]