Averaging last four records

[Guest]

I am trying to set up a report which will only lookup the last four records
and average the data from only the last four records.

Records will be added to every day and the report will be run every day. As
records are added the new records becomes one of the four records to average.
As records are added the previous new record will eventually drop off of the
list to be averaged.

I hope I am making sense.

 

[Allen Browne]

Base the report on a query.

Sort the *query* in descending order by the field that indicates the
date/time it was added. (You can sort the report differently by using the
Sorting And Grouping box in report design view.)

In query design, open the Properties box, and enter 4 beside the Top Values
property.