I need to run a report that is grouped by week, in that report I have sum columns which are working great, but the one column that I can't get to function correctly is to tell me the last entry total(manually entered) for that week.  ie; number of volunteers is 44 one week, 46 2nd week, 45 3rd week, and 44 the 4th week.  In the report I want those numbers to show up for the week and then the Grand Total to be the average # of volunteers.  I tried to do a Top 1 SQL but I can not get it to work correctly.