We have a query that we need the "distinct" value count.
On the attached screenshot, you will see per week we need a count of locations that ordered. not the "# of orders".
For example, Fort Bragg Honeycutt Shoppette has 2 orders for the week of 12/2/2013. We want to only have it count "1" because they ordered.
I have found that there is an add-on, but we are not permitted to install on the Company's Terminal Server.
Thank you for your assistance!