I am looking to create either a managerial Query or Report for KPI use.
The report essentially is going to report on all changes done by a particlar department.
This department is tasked with creating items, revving item revs, and statusing item revs.
My stretch goal would be to just display a simple number of these changes based upon a date entered. However, as a fall back plan I would be ok with a list of items revs as well. The manager can then just export the query results or report to excel and count the rows.
The issue here is that I want this fairly simple. I can use AND in the Query search criteria to put together the three reporting factors, but even though the date on each search criteria the date would need to be entered into each field.
For instance for item revs I would use creation_date Created after >=07/29/2017. However, in the query I would need to enter the same date into date_released Released after >= 07/29/2017.
For a manager this just seems silly. In some way it is silly to be concerned about the one extra step however far less expensive systems based on databases can do this easily.
How do I create a date data entry field that will then populate all date data in the query?