I am having some trouble creating a DSum function in a MS Access query. The function is supposed to:
sum Actual Sales
where RawDataMain ID = RawDataMainID AND MonthID <= MonthID
The RawDataMainID refers to a particular market and product.
Here is the code that I have:
RunningSum: DSum("Actual Sales","tblRawDataSub","Ra
D = '" & [RawDataMainID] & "' and tblMonths.MonthID <= " & [tblMonths.MonthID])
Can someone please tell me where I am going wrong?