I really am struggling with this.
I have a form that enters the time a user clicks a button.
It is used to record the number of pallets that were made in a shift. Three shifts 08:00-16:00, 16:00-00:00 and 00:00-08:00.
I have setup three queries to get the number of pallets per shift (Day, Eve, Night) I have done another query, (qryAllDay), to group the Day,Eve,Night shifts to display a graph on the only form in the database showing pallets made over the last three shifts.
I need the graph to show only the pallets from the current shift (based on time) and the previous two shifts. I just cannot fathom how to make the query reflect this.
I have attached the database.
As always, your time is much appreciated. ToyPalls.accdb