ill work on a total re-write. a query that starts with available coaches that joins subqueries that show availability, vacation, and conflicting classes. one big query instead of query after query. will definitely perform better.

regards,

Danny

ps: the reason it was not written like this in first place is bc it started as a single task and we added more and more to it, no explained here (like show close classes starting/ending with +/- X hours and mins, consider a coach to be 'free' it he/she is staffed in overlapping class where there are no clients to it, the option to show busy coaches and teh remove from conflicting classes, etc.)

thank you all.

munscio