Please answer need help desperately

[ineedhelpnow]

I have created a basic database but now need it to perform some difficult tasks (Well difficult to me) an havent a clue how to do this.

I need to be able to search the database for a vehicle type for a specific dat to see whether it is available or not?

and i need to be able to produc a list of vehicle & drivers that are not booked by entering a date?

Has anybody got any ideas on how to do this because its racking my brains

Thanks

 

[GumbyD]

You should be able to create queries to get the information you want if your database is built correctly. You may want to post your database so people can look at and give you suggestions about how to accomplish what you need. No one will be able to help you without know the table structure and field names, so you should at least post that information.

 

[ineedhelpnow]

I have TBLVehicle and TBLDriver created and they contain data if that helps any further? or do you want me to post the database?

Inside TBL Vehicle i have

VehicleID
Vehicle Type
Cost Per Booking
Driving Skill Required
Capacity of vehicle
BookingId* As a foreign Key

In TBL DRIVER i have:

DriverId
Surname
Forename
Address Line 1 , 2, 3
Postcode
Telephone Number
Driving Skill
Cost Per Hour
Wage Per Hours
BookingId* as a foreign key

Thanks again

 

[GumbyD]

Is there another table called Bookings or something? How are these tables related - is it through a third table? If you post the database I will try to create an SQL statement you can just copy.

 

[GumbyD]

Is there another table called Bookings or something? How are these tables related - is it through a third table? If you post the database I will try to create an SQL statement you can just copy.