Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-02 : 09:31:41
|
| Ling writes "I am using MS Access. I ask many ppl n not many ppl could answer my question. So, hope don't mind I post it to you. I have a booking database, a facility booking of sports courts. I have a table name Booking with fields like timein, timeout, datein, dateout, UserID, CourtID. How do I detect a user has already book that certain time and response with sentence that it has already been book. For example, Mary book a badminton court from 8-11am on 30th dec. Later, Lucy wants to book that badminton court from 10-11am on the same day. How do I query the database for that range of time? Same goes for the dates as I want to do block booking. I have ask many people on this, and not many people could answer me. Hope you can help. Thanks. =) If still don't understand my question, please email me." |
|
|
|
|
|
how to query a range of dates?