troubleshooting Question

Access - Query Cumulative for day by TransType if No TransType is Subseq Shift

Avatar of wlwebb
wlwebbFlag for United States of America asked on
Microsoft Access
11 Comments3 Solutions142 ViewsLast Modified:
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....

Any help?? or suggestion...

Attached is a stripped down version
Cumulative-TransType-By-Day.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros