This is similar to another post: Consolidated Count from another table by date field, however I am trying to group by 2 fields.
Table 1 has 3 fields (Date, Shift, Count)
Table 2 has 3 Fields (Date, Shift, Total Count)
Table 1 has 6 records:
Oh, I hadn’t even thought about having one record per date with a count field for each shift. I was thinking of having one record per date per shift. Either should work for what I need :slightly_smiling_face: