Hello everyone!
this is my first post here - for a long time this forum was a great source of knowledge for me, so decided to register
My problem:
I have a form that shows results of crosstab query.
In Detail section there are students names, their exam results, summary of results for each student and count of subjects each student took part - all from query. Then there are calculated text boxes that use those exam results, summaries and counts to calculate residuals for each subject.
Form footer is the place where the problem happens - I built text box that calculates average of those residuals and as long as there are residuals above in Detail section, this box works, but if there is a subject that noone took part and its residual box is Null - all my text boxes in form footer change to #Error
Pleas ehelp me out here, cause I tried lots of things, nothing worked, but I'm sure there is a way to go around this issue.
Let me know if you need any more details!
Thank you!
this is my first post here - for a long time this forum was a great source of knowledge for me, so decided to register

My problem:
I have a form that shows results of crosstab query.
In Detail section there are students names, their exam results, summary of results for each student and count of subjects each student took part - all from query. Then there are calculated text boxes that use those exam results, summaries and counts to calculate residuals for each subject.
Form footer is the place where the problem happens - I built text box that calculates average of those residuals and as long as there are residuals above in Detail section, this box works, but if there is a subject that noone took part and its residual box is Null - all my text boxes in form footer change to #Error

Pleas ehelp me out here, cause I tried lots of things, nothing worked, but I'm sure there is a way to go around this issue.
Let me know if you need any more details!
Thank you!