Jason, I am still having trouble with this query... to eliminate any errors that I might have on my PHP page, I have simply opened the query window in Navicat so that I can test the query against the database without needing the web page.
It seems like when I use only the select statement, the WHERE statement and limiting the group statement to "GROUP BY users.user_Id", the sum(run_Qty) is accurate.
When I add "Having runs>=10, the results are still accurate, and return only users with a sum(run_Qty) of 10 or more.
As soon as I add the date comparison, my result is 1 row, all null?
Should I be approaching this differently?