Lo All o/
I am trying to get an accurate count of unique values (in a single field, such as "Order Numbers" & "Won") and am not getting the right results. I have attached five screen shots:
- The inaccurate results of the intended distinct count query
- The query design view for 1.
- A validation query I ran showing the correct number of total order numbers
- The query design view for 3
- A pivot report I created in Excel as a redundant validation
1 should match the result of 3 & 5, but it isn't and in 2's query I have tried both unique values & unique records. What might I be doing wrong?
Thank you kindly