Hi,

I got a query the other day from someone wanting to know what rooms were available in our database, on a Friday afternoon from 2pm -5pm, weeks 1-11 in a lecture theatre greater than 100. I wrote a Crystal report, that unfortunately didn't work. I was wondering if anyone had a similar room checking report, that I could use.

I had to go down the usage chart for Friday in those weeks, looking for rooms that I had queried in crystal that had over 100 capacity. Not the best thing to do.

Thanks

Rick