Access - Query Cumulative for day by TransType if No TransType is Subseq Shift
I am trying to create a Query to Sum information for each Shift in a Business Day and show the Cumulative Amount for each Day for any TransTypeID. If a Day's subsequent Shift doesn't have a Transaction for the TransTypeID that an earlier shift has, I still need it to show that Cumulative for the Day info.
The Cumulative by Day needs to report by TransTypeID =5 or null. (Null so that if there aren't any Transactions in a Day I'll have a record with a zero for forms and reports.
If ShiftSeq number 1 of the Day has a TransTypeID = 5 but ShiftSeq 2 or 3 of the day doesn't, then I can't get it to show a record for that ShiftSeq showing the cumulative for the day....