Tech Support Guy banner
Status
Not open for further replies.

Need Help to Find Available Rooms on Date Input using Access

Solved 
808 views 4 replies 2 participants last post by  Keebellah 
#1 ·
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
 

Attachments

#3 ·
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
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top