How do you create a running average in an unbound field in a form. For example, line 1 will just be an average of itself. Line 2 will be an average of line 1 and 2, line 3 will be an average of line 1, 2, and 3... and so on.
More info is needed.
What are you calculating the average of?
(You can't calculate the average of an unbound textbox, as by definition it would always be the current visible value)
(I am sorry..I am not a technical user...I am using my husband's account) I have a subform that has a Price column and the next column I want to have a running average of the Price column.
To do this you must have a unique id for each record in the subform (not necessarily unique across all records in the table) and the records must be listed in that sequence (ascending or descending).
The subform must be based on a query. It is necessary to add an extra column to the query to represent the running average.
The extra column would look something like:
I am assuming that mylinkfield is the field that links the form and the subform to each other...which is a text field not numbers. How do I adjust the syntax for this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.