I have 3 tables, Products, Stock In, and Stock out. I currently have a sum on the products table which looks a little like this.
Column is [Stock Level]
SUM([Related In][Qty In]) - SUM([Related Out][Qty Out]).
I need to add another level in which I need to only show stock level by UserEmail(). Both the Stock in and Stock out tables will contain UserEmail() so I need to add this somehow. hope this makes sense?
Thanks
Antony
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |