Hi All,
i have query that calulates the month spend in one column [Month_total] then i Group it via the month using a field called [Month_] then use a sum on form to call the values
like
=DSum("[Month_Total]","[Monthly_Cost_parts_QRY]","[Month_] = '3'") which shows the total spend for march...