The problem is this - I dont want the query to return all records if the criteria isnt matched ... each day it needs query the next two fields for...

Thanks for the input -- I found a soulution to that particular problem.

I have a second question: Can you code SQL to delete the first set of criteria after running...

Due to specific reports that need to be run - this was the simplist way to set the tables up.  I agree that a single date column would have been...