To find the vehicles that are available from one date/time to another, you
need to locate those have no booking for any period in that timeframe. The
basic idea is that two events overlap if both:
A starts before B ends, and
B starts before A ends.
If you have to handle Nulls (e.g. not known when the vehicle will be back),
it gets a bit more involved. See:
Clashing Events/Appointments
at:
http://allenbrowne.com/appevent.html

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> Hello,
> I'm new at database design and I'm trying to make my first real program.
[quoted text clipped - 18 lines]
> Now i'm not sure how to do the reservation part in table design.
> Any suggestions
Stefan - 25 Apr 2005 16:50 GMT
thanx allen
that's what i was looking for
> To find the vehicles that are available from one date/time to another, you
> need to locate those have no booking for any period in that timeframe. The
[quoted text clipped - 30 lines]
> > Now i'm not sure how to do the reservation part in table design.
> > Any suggestions