Matching similar time frames between tables

... and do they all start on the hour?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Hi Mark.  They could be an hour, but could be several.  The providers are working with autistic clients that have different needs, so the times will vary.  They might be there for 2 hours, or it could be 5, etc.  It's an ongoing schedule every week.  They would go at the same time each week for the same amount of time.  Every morning at 9am till noon for instance.  The time frame is known, but varies between clients.  

I basically want to see which clients have time frames that fall within the providers time frame.  A provider may work from 9 to 5, but could have several clients.  One in the morning, one mid day, and one later.  A staff member would look at the potential clients and then manually decide if there is a good fit for the providers schedule. 

Thanks

------------------------------
Dana Hauser
------------------------------