Search results

I tried it as well, but didn't work:( There must be some rule for Access that I'm missing... See, for some reason if just one calculated text box gives error, then all boxes in this form turns to errors as well! What is that?!:eek:

is there a way to calculate it like: "for all residuals that are not null, do average"? Is there a way to use FOR clause in expression builder? I know there is DLook but that would have to base on table or query... is there any function that checkes form results?

Sorry, what do you mean? there is Art field on the left, it has art result.

Problem is residual can be 0, in this case I won't know if that is real 0 or it is zero cause there was no result on left side of the form. Let me show you what is residual: For example student residual for Art would be: Average of all other exams of this student eccept Art - Art result. That...

Basically its is the same as avg only without avg... for some reason avg box only works if I use full formula, not only name of the residual box from details section.. madness! :( two days I'm trying to make it work...

I'm affraid I can't:( is ther anything you would like to see, maybe I could paste crosstab query, or some part of db?

You're right, I cannot use Sum or Avg or any arithmetic function on null.. So what can I do with it? It works if there even one subject, right? But how can I change it to show empty field for Nulls? For some reason IsNumeric doens't work for that, which I thought it will.

Thing is, this is the formula for average of that art. Box above it, in detail section is the art residual that is shown for each student, called ArtRes. I wanted to get Avg of each subject, but as soon as I easily use "Avg([ArtRes])" it comes with #Error. So what I had to do is I copied the...

Hi - thanks for reply! To show the text box , this is the formula for those calculated averages in the bottom of the form: =Avg((IIf([SubjectCount]=1,Null,(IIf(IsNumeric([Art]),(([Summary]-[art])/(Nz(([SubjectCount]-1),1))-[art]),Null))))) Here is the form screenshot to make it more visible....

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...