I am doing an running total in a query from a Table
Fields of the Table are
SELECT Compliance.[StageID], Compliance.[MonthYear], Compliance.[Field Name], Compliance.[Field Value], DSum("[Field Value]","[Compliance]","StageID <" & [StageID]) AS expr1
WHERE (((Compliance.MonthYear) Between [sd] And [ed]) And ((Compliance.[Field Name])="Total Afd CPE Transactioned"));
The problem here is as doing running total for all other fields, not just for "Total Afd CPE Transactioned"