first of all im new to this forum ( )

well,

Im trying to bulid a databse for a transport company using access 2007
when its come to transport the date and time is very important (right).



so i made 4 fields for 1start date 2end date 3start time 4end time like in the event scheduler. bcz i need to get results for like which car is available at this time

any ideas for how to do this??

overall is some thing like this
unused cars at this time = (start date,time - end date time)
if end time is reached show the car no in the availble car list

please somebody help