For some reasons, I always have issues with DSum or DAvg calculations


table name: systbl_month
field names:
Quantity
Date

Objective:
Trying to get a rolling 28 day average


Any ideas?

Davg("Quantity","systbl_month","Date > " & Date()-28) should do it

make sure to use the quotes

and just to note, dont call a field Date. or any other reserved word. You can end up running into all kinds of problems.