I am trying to calculate a rolling 8 week rolling average for several entries that are made on a weekly basis.  Each week the following fields are entered:

1. Date

2. Weekly Revenue

3. Weekly Labor

4. Weekly Spread

     I am trying to take the 8 most recent entries (weeks), and average them out and display the results...   Any help would be very appreciated..

Thanks

Nick