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...

this is all for a SINGLE CLASS DAY.

the plus second is to find overlapping/close classes. i have to make a drawing to came up with that logic. the...

Thanks Kevin.

Ill investigate that

Hi again. Sorry if i wasted ur time. here it goes on details...

<%

'this_claday_date, this_claday_datenumber, this_claday_starttime, this_claday_endtime taken from the CLASS DAY im staffing

'rsdetails("coachid") is the Coach Id taken from the...

Thank you all. I knew it was goona be a difficult post....I think that in order to pinpoint a problem there are things that should be taken for granted. I...

Thank you! will do tomorrow, im leaving the office. good nite