Ok, look at this report I have created. Tell me how can I get one single total per Batch Number ID? As you see here it adds a total per error. In some cases a user will have several batch number IDs with several errors and I want to total each document count in each individual Batch number Not per error? Can someone help me figure this out? I am at the end of my project and this one issue is making me NUTS.

33515:confused:

You could use Database functions which will help you, there are examples in the Help System. DSUM, DCOUNT etc.

Another option is create a query and use totals then place the query in the report footer or Header this then gives you a summary of your totals.