Thread: Forward booking
View Single Post
  #1 (permalink)  
Old May 25th, 2004, 06:12 AM
rahilahmed rahilahmed is offline
Registered User
 
Join Date: May 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Forward booking

I hope someone can give me an idea of how to achieve the followings:
I am working on a forward booking system, the item should be able to be booked for the period it is not booked so potentially the dates could fall between 2(two) booked dates, example item is booked for 12 dec to 13 decemeber and then for 16 dec to 17 dec, then if someone wants to book for available period between 14 and 15 th, they can do that. I ll apreciate any help on the kind of SQL statement or logic.. by the way I am using VBA for excel and access .... Thanks

Reply With Quote