Question on creating a particuliar calculation in a Access 2010 query

Ketcham488

Registered User.
Local time
Yesterday, 21:43
Joined
May 27, 2012
Messages
10
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
 
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.
 

Attachments

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

Users who are viewing this thread

Back
Top Bottom