machumpion
Registered User.
- Local time
- Yesterday, 23:55
- Joined
- May 26, 2016
- Messages
- 93
Im running a query of customer sales in a particular period
A customer can have multiple orders in one period (one order per product)
i set the Date field criteria >#7/30/16#
I set Sales field = Group By to view the individual order $$s
when I go back to query design and only change the Sales = Sum, so i can view the total value of orders in that period, the total sales of each customer is different than when adding each individual order under the 'group by' query. In particular, it looks like in the 'sum' query, individual orders were multiplied by 2.
Why is this happening?
Thanks!
A customer can have multiple orders in one period (one order per product)
i set the Date field criteria >#7/30/16#
I set Sales field = Group By to view the individual order $$s
when I go back to query design and only change the Sales = Sum, so i can view the total value of orders in that period, the total sales of each customer is different than when adding each individual order under the 'group by' query. In particular, it looks like in the 'sum' query, individual orders were multiplied by 2.
Why is this happening?
Thanks!