Access 2007 Sql Query
Hi Team (Again).. further to an original post I am trying to get 2 further fields added to my Query / Report. BoxCount & AverageWeight Here is the existing query. SELECT Pickerid, Pickername, ROUND(SUM(totalweight), 2) AS PickersTotalWeight, SUM(totalweight)/ROUND(SUM(pickerhours)) AS HourlyRate FROM (SELECT pickerid,currentdate,pickerhours,pickername,SUM(currentweight) AS totalweight FROM mergeddatabase GROUP BY pickerid,currentdate,pickerhours,pickername) AS [%$##@_Alias] WHERE ((currentdate between [...]

Answer Question   |  September 13, 2012  7:14 AM
Access SQL Averaging, Counts