The database opens up to an operational date selector, which controls a form for operational dates as the only field. Once the new operational date is entered, the form closes. I have a separate table with operational dates for the tills being signed out, as well as departments worked with the till and of course the employees who they were signed out to. Ideally, I would like to just filter the query records by those with the reported operating date selected at the beginning from the first form. This is not a current date calculation, as I want to view records even after midnight because we balance tills pretty late sometimes into the next day.
I have tried Max with MostRecent SQL and a subquery. This would work but there are several of each kind of till for the operational day. I'm trying to make a form/subform combo that shows each signed out till by department (combobox selection), only displaying the previously selected operational date (typed in on opening form). I have only managed to make the department selector work, but it still shows every till signed out since 2013. I'm still very new to Access so what is the best way to set up the query to display only records with the one-time selected operational date without a seperate combobox to select that date every time?