I finally figured it out finally after 3 days of trying various things. It probably isn't the best way of doing it, but it works.
I took each set (beginning/ending) and made it a stand alone query with the criteria using data from the input form. And I used the Or option in the criteria to allow...
In my example, I have an input form that will be used to drive a query. The purpose is to allow the user to enter a part in a category and it search to find if that entered part was originally installed when the machine was built, or possibly later it received it, or maybe it didn't receive the...