can someone helper for a project please very important

[Jean-Daniel]

i'm working on a database in access, for hotel reservation, there is for booking, date in and date out for each reservation and for different room, my teacher ask me how would i make sure that when a client come and reserve the same room that another client has reserved, he did it in a different date in and date out??? please help, he ask to create a queries but it does not working, please how would i make it please??

[June7]

What do you want the query to show:

1. only those rooms that are available for the given date range

or

2. all reservations for the specific room for the given date range

[Jean-Daniel]

sorry dear excuse, i want when i'm selecting a date, in the booking form when booking a room, if the room is already book on durant that period of time, it tell me that i can't book it that all

[Jean-Daniel]

sorry dear excuse, i want when i'm selecting a date, in the booking form when booking a room, if the room is already book on during that period of time, it tell me that i can't book it that all,

a. just like a check that is a room can be book by only client for a specific date in and date out

[Jean-Daniel]

oh sorry to disturb against, by the way if you could help me how to create this type of query that i'm asking ok :-), and also i will be thankfull if you give me the two type of query that is the answer a and b, i will try something also. thx

[June7]

A query can't tell you that you can't book, all it can do is show records according to criteria provided. You will have to evaluate the results and decide what they mean.

What you can do is have code that will do a search of records according to criteria and give a message that is dependent on the result of the search. That code would probably be VBA (I use only VBA, not macros).

Don't know your data structure so can't offer specifics.

Also, not going to do your homework. If you are confused, suggest you get guidance from instructor.

[Jean-Daniel]

oh ok but can you help me to create the two query you give before please

[June7]

As stated, don't know your data structure.

Maybe reviewing other projects will help you. http://www.brighthub.com/computing/w...les/76613.aspx

[Jean-Daniel]

oh thank
1. only those rooms that are available for the given date range

or

2. all reservations for the specific room for the given date range

can u give me an idea how to create these 2 query please

[June7]

Google: sql query room reservation

Review
http://support.microsoft.com/kb/245074
http://us.generation-nt.com/answer/s...200169541.html