monkeyharris
Active Member
- Joined
- Jan 20, 2008
- Messages
- 358
- Office Version
- 365
- Platform
- Windows
I need to populate a table from the below data. Firstly i need to show how many deliveries a person has made on each day but only by unique sales order number. IE: On 1st June Colin did 1 delivery. His name is mentioned twice on 1/6 but sales order is duplicated. Any ideas?
Date Expected | Route | Drop: | Vehicle | Sales Order | Driver |
01/06/2020 | TRIP 1 | 1 | DK17LHE | 214108 | Mark |
01/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Colin |
01/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Colin |
01/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Andy |
01/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Robert |
02/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Tony |
02/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Tony |
02/06/2020 | TRIP-2 | 1 | DK17LHE | 214425 | Tony |
03/06/2020 | TRIP 1 | 2 | DK17LHE | 214427 | Colin |
03/06/2020 | TRIP 1 | 2 | DK17LHE | 214427 | Colin |
03/06/2020 | TRIP 1 | 2 | DK17LHE | 214427 | Colin |
03/06/2020 | TRIP 1 | 3 | DK17LHE | 214439 | Mark |
03/06/2020 | TRIP 1 | 3 | DK17LHE | 214439 | Mark |
03/06/2020 | TRIP 1 | 2 | DG16DVX | 213054 | Andy |
04/06/2020 | TRIP-2 | 1 | DG16DVX | 213152 | Andy |
04/06/2020 | TRIP-2 | 1 | DG16DVX | 213152 | Andy |
04/06/2020 | TRIP-2 | 1 | DG16DVX | 213152 | Colin |
04/06/2020 | TRIP-2 | 1 | DG16DVX | 213152 | Andy |
05/06/2020 | TRIP-3 | 1 | DG16DVX | 213943 | Robert |