From the data you've provided, I really don't see any reasonable means to reliably return the results you desire.
The best I can tell you is that you either have not provided enough of your dataset to for us to help and/or your database design has failed you in the most miserable way possible...
So what I'm going to ask you to do is:
1) Go back to your data. Almost anything in addition to what you have here might help.
2) reveiw the following sites for how to design a RDMS.
---
MS Access 2010 Tutorials Access Basics - By Crystal Micrsoft: Office2010 tutorials Microsoft: Getting started with Access 2010 > Database Normalization and Table Structures.
---
3) I am abhorent to provide the following:
Based on the data you posted in #1
- SELECT TOP 3 Table3.Completion , Table3.Production
-
FROM Table3
-
WHERE ((([Production]>=[Completion]));
-
This will return the first three records wherein the production date is greater than 1/9/2009 the 2/1/2009 - 4/1/2009 IT will not return the 1/1/2009 because that date is greater than the 1/9/2009
FURTHERMORE: Even if you add 100 more records, it is only going to return 2/1/2009 - 4/1/2009
You see, you've really not given us anything to really work with.