Hello,
I have a query with a list of my customers and there is a field with TOTAL SALES with that customer (sum of order items). I would like to display sales only realized this year next to it.
I tried this:
First column in design mode:
TotalSales: Price
tblOrderDetails
Sum
This correctly shows total sales realized with that customer.
The second column looks like this:
SalesThisYear: Price
tblOrderDetails
Sum
Criteria: Year([tblOrders.OrderDate])=Year(Date())
What happens is that it shows only THIS YEAR sales in both the columns. And it doesn't show customer with ZERO sales this year. How can I fix this please?
Thanks,
Tomas