Good afternoon
I am seeking assistance with a query that uses "distinct count" to count individual sales orders numbers per day. I have a query set with 3 columns - Load date _ Order No _ Site No. This query runs on a "Between [start date] and [end date] range in the load date column and pulls in all the sales order numbers, many of which are duplicated.
I then have a second query which counts the distinct sales order numbers in the first query for a single day, all it displays is the number of distinct order numbers, I know nothing about SQL but I managed to copy some bits off of forums to get this to run, it is set as below
SELECT Count(*) AS Expr1
FROM (SELECT DISTINCT T1.[Order No] FROM [Daily Order Count] AS T1) AS T1
I would like the query to show the distinct count of sales order numbers and also display the dates in a range so I could view a weeks at a time by and also display the sites ,however as this is well out of my knowledge range I would not know where to start so I am hoping somebody can assist.
Many thanks in advance