问题描述
我已经获得了一个项目来创建预订dbase的房间，并希望在我保存之前搜索当前记录以验证预订。
我的预订记录包含以下信息： -
tblBooking
日期StartTime EndTime RoomNo
10/10/2011 9 AM 1PM 7
10/10/2011下午1点4点7
10/10/2011 9AM 2PM 1
10/10/2011 3PM 5PM 1
12/10/2011下午5点1
frmBooking
如果我预订房间1（比如）10/10/2011下午2点到下午4点（比如说）我需要看看在tblBooking中检查房间在这个日期和时间是免费的。
任何人都可以就此提出建议。
I have been given a project to create a room booking dbase and wish to search current records to validate a booking before I save it.
My booking records contains info like:-
tblBooking
Date StartTime EndTime RoomNo
10/10/2011 9AM 1PM 7
10/10/2011 1PM 4PM 7
10/10/2011 9AM 2PM 1
10/10/2011 3PM 5PM 1
12/10/2011 5PM 6PM 1
frmBooking
If I make a booking for Room 1 for (say) 10/10/2011 for 2PM to 4PM (say) I need to look in the tblBooking to check that the room is free on this date and time.
Would anyone be able to advise on this please.
这篇关于如何检查周期是否重叠的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！