Query Help

[JIT]

I am currently trying to run a query that will give me a report coming from a
table with these fields: City, Trailer #. I need the query to list the
trailer #'s for each city within a certain date range. However, I only need
it to show the total amount of trailers for each city, not list each trailer
individually. How do I accomplish this by using a query?

Thank You.

 

[Dennis]

Create your query with City as the first column and trailer # as the second.
Click the sigma (totals) button on the toolbar. Leave the City as 'group by'
but change the trailer # total row to count. Run the query.