Hi

I need a little help for my assignment. I am doing a program for a car rent company (made up one).

What my problem is when a customer reserves a vehicle and another customer also wants to that same vehicle they should click on check availaility button to see if that vehicle is available or not.

way it should work is once one customer has reserved a vehicle with a specific start date and end date the button checks the vehicle, start date and end date and give a message to the customer tell them if the vechicle is available or not.

I have started it off but i am stuck in creating this function.

here is a link to the program
http://limpep.pwp.blueyonder.co.uk/excelprogram.html

If any one can help i will be very thankful


Thanks