Hello everyone.  I just completed building a report that I thought was awesome.  I shared it at work and then noticed the sub groups are totaling as I wanted, and then the whole category totals, then it moves to the next product using the same format.  What happened is that MOST subtotals are correct, but a few don't add up correctly.  At further scrutiny, I can tell that a line item did not show up in the report, but the totals are correct (they re using the data, just not showing it).  The data came from a query and I can see the missing line items in the query.  The report is 20 pages and most are correct.  So, I have gone from a nervous beginner, so feeling pretty pumped last night when the report finally came together, and now I am back to feeling like a confused newbie. Is there any type of easy answers to this situation?  Hoping someone says "of ya, that happened to all of us when we started out".  lol.  (This is a brand new database that I am still getting the data into and checked for integrity), but I have been able to pull out what I need when I need it.  I am just starting to go back and build the reports they will need and then set up for other people to use later.  So, for now, I would like to have some confidence that this is the answer to the company's woes... in this moment, I don't have it.  Help!