Search results

I completely understand, I was not expecting people to go out of their way to make a test database for a small problem such as this. Thank you for the help, your responses helped me to think about the problem from different angles.

So I actually found a workaround that works for what I am trying to accomplish. I made another text box and labeled it Date End and renamed Date as Date Start. My Criteria is now: Between [Forms]![ShiftSearchForm]![DateStart] And [Forms]![ShiftSearchForm]![DateEnd] This works perfectly, and if...

I am sorry, but that will prove to be too difficult to work with the way my data already is. (I know, I am not helping much, and I appreciate you trying to help me) Maybe if I simplify my question: How do I get records (each including a date) to show the date that is searched and the following...

I don't think that is what I am looking for. Im having more trouble with the criteria where it takes the date and shows records for that day plus 6 more days. I used Like "*" & [Employee] & "*" for my employee and team combo boxes to account for empty boxes.

Hello, I am fairly new to Access. I got the basics down, but I am not too familiar with SQL and VBA. I am trying to build a query that returns back records based on a Date field. I made a "Search Form" for people to input information such as: (all of the following are unbound) Employee...