Subtotals in reports are calculating incorrectly.

[Long Tom Coffin]

I'm attempting to put together one last report for this particular database, and then it will be completed. Unfortunately, I cannot seem to get the subtotals working right in the report. I am attaching a copy of the database. The report I'm concerned with is "Total Report". I have been using the "Totals" button inside the design view, but while it calculates some totals correctly, it also miscaclulates others.

Any suggestions?



Experimental copy.zip

[amrut]

While in report's design view, click on "Groups & Sort". Click on the relevant group --> More --> with totals-->Select your field to "Total on" and check the box for "Show sub-total in group footer"

[Long Tom Coffin]

While in report's design view, click on "Groups & Sort". Click on the relevant group --> More --> with totals-->Select your field to "Total on" and check the box for "Show sub-total in group footer"

Doing this is what is getting me the wrong subtotals. For example, while trying to group and subtotal by allotment, it will return the actual allotment 5x over, instead of the true amount

[RayMilhon]

Looked at your query according to what I'm seeing you have 6,300,000 in each record of the sumofobligationamount. In the previous column obligationamount totals to 9,600,000. 6,300,000 on 06/29/2012 and 3,300,000 on 6/27/2020 and 7/3/2012. Somewhere there are 2 different dates for the same obligation amount so those 2 records are having the obligation amounts added twice. You need to look at each query if the query is based on another query go back to the beginning and find where the oblication amount is duplicated and fix it there.