KathyRayG77 KathyRayG77 Today at 7:04 AM Computers and Technology Answered 19. open the sortedstates query in design view. modify the query to sort the state field in ascending order. each state should appear only once. save the query. open the query in datasheet view and then close it.