Create a new summary query in Design view. The query counts the number of tickets issued by city and violation.

a$.$ Add the Tickets table into the Query Design window.

b$.$ Increase the size of the table object to display all of the fields.

c$.$ Add the following fields into the query: City, PrimaryFactor, and TicketNumber.

d$.$ Add the Total row to the query.

e$.$ Group By the City and PrimaryFactor fields and Count the TicketNumber field.

Save the query as TicketCountByCityAndFactor.

$$ Run the query. The datasheet should display $22$ records.

$$ Adjust the field column widths using AutoFit or Best Fit. The datasheet should be similar to Figure $3-116.$