unmatched query - free rooms?Urgent Help!

[Blackwidow]

I have two tables tblAutomaticSchedular holds all the timetable information
and tblrooms holds all the rooms we have in the school

I have created a query called qryroom which narrows tblAutomaticSchedular down to a particular time and day... using [Which Day?] and [What time?] in the query...

Basically I want to know which rooms are free at the time selected... have tried to do an unmatched query but to no avail... any help would be greatly appreciated... our main system that does this usually has crashed across the whole city... and the back up is my database which also holds this information....

Please Help!!

 

[raskew]

Hi -

Take a look at Allen Browne's excellent article here.

HTH - Bob