Recent content by SQUIZZ

Sorry I didn't explain that very well. The values (pupils levels) are entered via a form and are recorded in a main table with field names R1 - R16. Let us say that when the average of these values are required, values have been entered via the form for fields R1 -R9. I want the query to...

I have a database containing values in 16 fields. the fields are filled in over a period of three years. I would like to be able to calculate the average of the last four values entered, regardless of when in the cycle the value is required. I have tryed to use quereies but connot find away to...