Hi Kirk,

I think you can use query from Re: Complex Query Help Thread #611652 Message #611826 to get "free spots" and add them to your query with UNION ALL.

>Hi everyone
>
>I use the following query to create a resultset of scheduled cases. I then run a vfp report against this cursor and print the schedule. It is ordered by room and time. Now they would like to have me extend this to show free spots that are greater than 60 minutes from the end each previous case on the schedule. I'm not sure how to rework the query to return something that is not there. This turns into a work schedule they can use after hours to and "write-in" the information.
>
>Thanks for any help
>
>Kirk
>
<snip>