I have requested a Premier appt, but am trying to resolve this today before i'm out of town for a while. I was able to make the following work,
SELECT users.user_Id, user_Received10, user_First, user_Last, user_Email, user_Size, runs.run_Id, runs.run_Date FROM users INNER JOIN runs on runs.user_Id = users.user_Id
WHERE DATE_FORMAT(runs.run_Date, '%Y-%m-%d') = DATE_FORMAT(NOW(), '%Y-%m-%d')
GROUP BY users.user_Id
ORDER BY user_Last ASC
Could I add a second RS to this results page that could perform the sum(run_Qty) as runCount using a variable like $_GET['user_Id'], and then echo runCount in the last cell of each row, thus displaying the total for each user?