If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

A) to the right of the City field
B) to the left of the City field
C) in the first column of the query design grid
D) below the City field

Question

Udodiri Enwerem · Accepted Answer

Final Answer : A, Explanation :  The LastName field should be inserted to the right of the City field. This will result in the query first sorting by City and then sorting by LastName within each city group.

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

A) to the right of the City field
B) to the left of the City field
C) in the first column of the query design grid
D) below the City field

Definitions

Learning Objectives

Learning Objectives

Related questions

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?A) to the right of the City fieldB) to the left of the City fieldC) in the first column of the query design gridD) below the City field

Definitions

Learning Objectives

Learning Objectives

Related questions

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

A) to the right of the City field
B) to the left of the City field
C) in the first column of the query design grid
D) below the City field