Actually, "Ed B" was right about this "do you need a single row per store and product, perhaps with the Pending and OnTheWay totals in different columns?".

Retail thinking is as...

I wish so much that I could do what you said and that you guys could help me 🙁 But unfortunately, I haven't mastered that much yet 🙁 The best...

I'm sorry for that. But if I knew that much, I would answer this question myself 🙂 I can give the attached excel example for the table and query. If...

• This reply was modified 2 years, 4 months ago by  tonic.