To calculate your moving average you could use this in your query:
MovingAverage: DSum("AmountDue","tblData","[paymentdate]>=#" & Format([PaymentDate]-6,"mm/dd/yy"

& "# and [paymentdate]<=#" & Format([PaymentDate],"mm/dd/yy"

& "#"

/DCount("AmountDue","tblData","[paymentdate]>=#" & Format([PaymentDate]-6,"mm/dd/yy"

& "# and [paymentdate]<=#" & Format([PaymentDate],"mm/dd/yy"

& "#"
It's not pretty, but basically it does a dsum of the AmountDue's which are between 7 days and today ago.
Not sure about the regression thing. I spent too much of my university life drinking beer or thinking about frinking beer!
B ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------