Query to filter classes that fall between two times

[Bkper087]

I am building a database to be used by a summer camp to schedule sessions and classes. I am trying to create a query where it will filter all classes that fall within a specific time range i.e.: 8:30 – 10:30. I have tried a between query; however, it leaves out classes listed for 8:30-11:30, because of the extended time range. I am working with a start time field and an end time field. Any ideas?

[pbaldy]

See if this helps:

http://www.baldyweb.com/OverLap.htm