Report summing incorrectly (access 2003)

[cyasuda]

I'm having difficulty with a report generating sums correctly... and am hoping someone here might be able to help me out (I have limited access experience, but more than other people in the office so I was tasked with fixing some broken databases).

This report is a summary of drugs by coordinator sorted by drug type. There is a lot of coding that I don't want to mess with if I don't have to-the person who built the database used temporary tables and such so that reports can be viewed by quarter. All I want this report to do is sum the totals for each of the columns so that we know how many vials of each drug each region has. However, all of them are adding incorrectly.



I read on another post that you can not do sums for calculated fields, so I stuck in the equation for #1 & #2... however they still do not add correctly (no matter what running sum setting I put it on). Similarly for the three middle fields all I have is =sum[fieldname] (I print screened the wrong field for the picture) but they still aren't adding correctly. It appears that they are in this screen, however on other pages there will be random numbers when there is no new transfers/received/used vials, and it does not add them up correctly when there are transfers/received/used vials.


I'm somewhat limited in that I can not share the database itself with anyone as it has restricted information in it... but I'm hoping that with my description someone might be able to help me/point me in the right direction of where to look for information about fixing this.

Thanks!

[June7]

If calc is done in query, creating a field, that field should able to be summed on report.

I will need to analyse project. Follow instructions at bottom of my post or upload to fileshare site such as box.com and post link to file.