Recent content by anaej

I used the example I found when I did a search on running sums on google.com. The DSum() I used was RunTot: DSum("Freight","Orders","DatePart('m',[OrderDate])<=" & [AMonth] & " And DatePart('yyyy',[OrderDate])<=" & [AYear] & "")

I did just what you suggested and I was able to make the running sum work in Northwind. That's why I posted my problem here. I applied the same knowledge from Norhtwind and it didn't work. So I thought maybe I was doing something obvious that someone else would pick up on. When I get a value...

I attempted to create a running sum including the other fields and I could not get the running sum to calculate correctly. So when I couldn't get the running sum to work using 3 criteria, I attempted to create the query using only 1 criteria in order to try to pinpoint my problem and the query...

SELECT [Summary Log cost info 4].Year, [Summary Log cost info 4].Month, [Summary Log cost info 4].[Rec Location], [Summary Log cost info 4].[tps cat] AS Category, Left([po_no],5) AS [Supplier No], Sum([Summary Log cost info 4].[Total Cost]) AS [SumOfTotal Cost], Sum([Summary Log cost info...

I'm attempting to create a running sum for a percent field I calculated but I can't get the running sum to work and I'm not sure what I'm doing wrong. The fields in my total query are year(group by), month(group by), category (group by), supplier (group by), total cost (sum), total wt (sum)...

I'm attempting to create a running sum for a percent field I calculated but I can't get the running sum to work and I'm not sure what I'm doing wrong. The fields in my total query are year(group by), month(group by), category (group by), supplier (group by), total cost (sum), total wt (sum)...