caroline2k13

Im wondering how to go about doing this query. I have to enter three start and finish dates for students, i need to be able to check Is finish date before today's date? Is start date being entered between old start & finish? if not adding to one due to above criteria to add to another Default to start 1/ finish 1 give warning if adding to overlap but will allow to override for instance finish 1 and start 2 are the same. When adding need to check dates in section 1, 2 & 3, adds to empty slot or overwrite/update section that has already passed