Question on creating a particuliar calculation in a Access 2010 query

[Ketcham488]

I have played with this problem for 3 days and have come close but not quite solved it. My problem, I have several drivers delivering several orders, the orders are named 101, 102 and so on lets say to 150. Due to locations of the drivers, some deliver more orders then others. I want to be able to create a report that looks like
"Driver #1 101 - 106"
"Driver #2 107 - 110"

Driver 1 delivered 6 orders. Driver #2 delivered 4 orders and so on.
I have tried the 'count" which gives me the number of orders per driver but having trouble figure out the design of the calculation in the query. Thanks

 

[Geotch]

step 1: If you are using design view in the query, click on the Group By button (Sigma). Group by driver, count of orders, min of order and max of order.

step 2: query off the first and format like you want it.

Here's a sample.

 

[Ketcham488]

Thank you Mr. Geotch, it worked perfectly. Have a great day!