I have a query that aggregates the results from about 10-12 other queries... then in another column I need to take these results and perform some calculations to them. I have totals on each column showing "group by" (if i don't have them set to "group by", then I get like 3000 identical results. So my problem is that when I use an expression to perform a calculation, it's looking at these 3000 some odd results for the calculations instead of just the single result in each column. I know there is something I've done wrong, but I can't figure it out. I've included my database if someone wants to look at it. Hopefully someone can help me out.

I am attempting to use Dsum for my calculations in the query called "BrandonsTotals-QRY". And this is the formula that is giving me problems. I am trying to add most all of these columns together and divide by "OilChanges" which is also giving me problems.



I would greatly appreciate any help anyone can give me. Thanks!