need help with this urgently.
I have a database with information relating to course timetables and i need to extract the information from the given criteria. The criteria specifies the school, course, venue, mode along with the Induction Date and the End date. I need to extract all the rows between the specified induction and the course end without having data from other batches showing up.
Currently the problem i am having is that i can extract the data within a date range but it gives me data from all batches.
I hope I am clear with my question