Courier Service.

[Jborg]

Hi Guys.

First of all I would like to thank you all for your postings because ever since I joined here, I learnt quite a bit more.

Now I need your advice.

I have been appointed to take over a courier service which our company is offering as a service to customers. So the basic operation is that we receive calls from customers to have packages for pick-up and to deliver to another locality. ( Basically from point A to Point B). I will have 4 couriers, having 4 separate vehicles. As such it should be very simple, but considering that I would eventually have to organize a route to all 4 couriers mixing pick-ups and deliveries in every locality. I guess I will have to insert a Job No: as a reference in both the pick-up address and the delivery address to match that particular job.

Can anyone illuminate me and enlighten me on how I should build a spreadsheet to plan this??

Thanks for your help in advance and Happy Easter Week-end to all.

J.Borg

 

[mole999]

there are some very good routing software out there for planning sakes, i'm going to suggest if you need to track and store data you have an MSAccess to store your clients/staff etc, and package details. Whilst you might start in excel to understand what you want to create, I'm of the opinion that its not the most efficient moving forward

 

[Jborg]

Thanks for answering Mole!!! very nice of you to have bothered. Yes I thought so, regarding Access. The trouble is that I am not bad in excel, but completely one level below a beginner with regards to Access. Looks like I have to take some lessons!!!

 

[mole999]

Have a look at the NorthWind Database example, last I looked that had a customer database and stock. It also has a built in invoice system

 

[Jborg]

Thanks. I will have a look. Great!!! and Happy Easter to you. Will tell you if this will be ok.