I hope someone can help me. I need to create a text box on a for
that will display a running 30-day average of a field. How would
code this so that each day the maximum number of days it use t
calculate the average is 30. :?

you could try using a DSum() function, where the criteria selects records
based on a date field in each record, something like

=DSum("[NumberField]", "MyTable", "[DateField] Between #" & Date() & "# And
#" & Date()-30 & "#") / 30

hth


"gemini2" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I hope someone can help me. I need to create a text box on a form
> that will display a running 30-day average of a field. How would I
> code this so that each day the maximum number of days it use to
> calculate the average is 30. :?:
>