You need to provide clarification around the choice of StartDate (field/object names should not contain spaces or special characters but we can proceed anyway).
This can be a prompt from the query itself, or user can input a date in a form text field.
This date can be used in a >= start date fashion (>= 06/25/2016), or you might want to present a list of month names in a form combo box...
Your query could be as simple as SELECT * FROM tblMyTable WHERE [BEGINNING DATE] >= tblMyTable.[Start Date];
This would not consider if an end date is present, nor would it restrict the records to "June" based on my date example.
Last edited by Micron; 10-16-2016 at 07:41 PM.
Reason: edit sql
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.