Need Assist to Find Available Rooms on Date Input using access query
I have attached a small access database, for which I'm trying to use a query to input a date and see what rooms
would be available on that one day at the different time slots when run.
Thank You for any assist. on this issue
John B
I'm no good at access but the query would be to loop through the room numbers on the chosen date and check the start and end time but I would not know how to do this in Access
Like I said, I'm not that good at Acess or SQL but I played around a little and ran this query
Code:
SELECT [QList Entered Date Rooms Taken].ClassNo, [QList Entered Date Rooms Taken].RequestDate, [QList Entered Date Rooms Taken].RoomAssign, tblStartTime.strtime1, [QList Entered Date Rooms Taken].EndTime
FROM [QList Entered Date Rooms Taken] RIGHT JOIN tblStartTime ON [QList Entered Date Rooms Taken].StartTime = tblStartTime.strtime1
ORDER BY tblStartTime.strtime1;
If you play around with it. Now it's sorted by room nr and the startime and the empty time slots are shown too maybe it helps
Glad that I could help you along even with my limited knowledge of SQL scripts
You're welcome.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!