I need a text box that is in a group footer that will call a Function named fSAR. I would like it to be global because I will use it in other reports. The calculation will be based on three records in my [Analysis] table:
I need to use the three entries when [AnalysisName] = 73,74, and 75.
A simplified version of the functions is:
fSAR = [AnalysisName]=75 / SQR(([AnalysisName]= 73 + [AnalysisName] = 74)/2) '75=the result for Sodium, 74=the result for Magnesium, 73=the restult for Calcium
What do I have to declare in the Function line and how?