So I have a report that I created based on a query.  All the data pulls fine.  I created some fields to capture a tally of the tasks that are completed during a given range of time entered by the user.  The report pulls perfectly- the only problem is that when I go to count the number of tasks it is not picking up all the tasks in a each grouping.  The report spans 1 week and is broken out by Business Line and then has a count of the tasks assigned to each product under that line.  In the Business Line footer is sums the number of tasks and sums the number of minutes for the entire business line.  It then goes on to the next business line and at the end of the report- there is a grand total of all the tasks completed by the team and the time it took for the week.  Within each group it is only giving me a total for 1 product...not adding them all together and giving me the total.  For instance If I have A business line called Fruit and the multiple reports that were run for the following products: apples, oranges, pears.  Its only giving me the total for apples... and ignoring the totals for oranges and pears.  So if its apples 5, Oranges 3 and Pears 2 that should be 10 tasks for business line called fruits.  Instead its only giving me 5.  I have tried everything I can think of to correct this and nothing is working.  The business line and products are combo boxes and are functioning correctly as well.  Please- any advice is appreciated.