Hello,
This might be a simple question (I hope so anyway). I am trying to pull a ‘Items sold in the past ## days’. So I have the order header, order detail and part tables linked. I filter the header ‘orderdate >= 01/01/2023’
I am getting the desired results, however I am getting multiple items (as expected since we sell parts all day long every day).
How would I get the unique values only reported?
Thanks!
Arno
Best answer by fred
View original