Calculation of unbound

T

truepantera

I understand that you cannot calculate an unbound on a report, but my
attempts at calculating on the original source isn't working either. I need
the average of the group.

Inside the detail section of my Dateofentry Group (Question fields are all
check box Yes/No
Text28=(Abs([Question1]+[Question2]+[Question3]+[Question4a]+[Question4b]+[Question4c]+[Question4d]+[Question4e]+[Question4f]+[Question4g]+[Question4h]+[Question4i]+[Question5]+[Question6]+[Question7]+[Question8]+[Question9]+[Question10]+[Question11]+[Question12]+[Question13]+[Question14]+[Question15]+[Question16]+[Question17]+[Question18]+[Question19]+[Question20]+[Question21]+[Question22]+[Question23])/(IIf([techscribe],31,12)))

Inside the footer section of Dateofentry group

text30=avg(=(Abs([Question1]+[Question2]+[Question3]+[Question4a]+[Question4b]+[Question4c]+[Question4d]+[Question4e]+[Question4f]+[Question4g]+[Question4h]+[Question4i]+[Question5]+[Question6]+[Question7]+[Question8]+[Question9]+[Question10]+[Question11]+[Question12]+[Question13]+[Question14]+[Question15]+[Question16]+[Question17]+[Question18]+[Question19]+[Question20]+[Question21]+[Question22]+[Question23])/(IIf([techscribe],31,12))))

Sometimes it gives me an error and sometimes it will not even let me preview
or run the report at all!

Any suggestions? Thanks in advance
 
D

Duane Hookom

If your table was normalized, you might not have an issue like this.
However, try:
=avg((Abs([Question1]+[Question2]+[Question3]+[Question4a]+[Question4b]+[Question4c]+[Question4d]+[Question4e]+[Question4f]+[Question4g]+[Question4h]+[Question4i]+[Question5]+[Question6]+[Question7]+[Question8]+[Question9]+[Question10]+[Question11]+[Question12]+[Question13]+[Question14]+[Question15]+[Question16]+[Question17]+[Question18]+[Question19]+[Question20]+[Question21]+[Question22]+[Question23])/(IIf([techscribe],31,12))))
 
T

truepantera

I got it to work! I created a record count unbound (invisible) and a running
sum of an unbound (invisible) then performed the calculation on those two
files. It works like a charm now!

Thanks
P

Duane Hookom said:
If your table was normalized, you might not have an issue like this.
However, try:
=avg((Abs([Question1]+[Question2]+[Question3]+[Question4a]+[Question4b]+[Question4c]+[Question4d]+[Question4e]+[Question4f]+[Question4g]+[Question4h]+[Question4i]+[Question5]+[Question6]+[Question7]+[Question8]+[Question9]+[Question10]+[Question11]+[Question12]+[Question13]+[Question14]+[Question15]+[Question16]+[Question17]+[Question18]+[Question19]+[Question20]+[Question21]+[Question22]+[Question23])/(IIf([techscribe],31,12))))


--
Duane Hookom
MS Access MVP


truepantera said:
I understand that you cannot calculate an unbound on a report, but my
attempts at calculating on the original source isn't working either. I
need
the average of the group.

Inside the detail section of my Dateofentry Group (Question fields are all
check box Yes/No)
Text28=(Abs([Question1]+[Question2]+[Question3]+[Question4a]+[Question4b]+[Question4c]+[Question4d]+[Question4e]+[Question4f]+[Question4g]+[Question4h]+[Question4i]+[Question5]+[Question6]+[Question7]+[Question8]+[Question9]+[Question10]+[Question11]+[Question12]+[Question13]+[Question14]+[Question15]+[Question16]+[Question17]+[Question18]+[Question19]+[Question20]+[Question21]+[Question22]+[Question23])/(IIf([techscribe],31,12)))

Inside the footer section of Dateofentry group

text30=avg(=(Abs([Question1]+[Question2]+[Question3]+[Question4a]+[Question4b]+[Question4c]+[Question4d]+[Question4e]+[Question4f]+[Question4g]+[Question4h]+[Question4i]+[Question5]+[Question6]+[Question7]+[Question8]+[Question9]+[Question10]+[Question11]+[Question12]+[Question13]+[Question14]+[Question15]+[Question16]+[Question17]+[Question18]+[Question19]+[Question20]+[Question21]+[Question22]+[Question23])/(IIf([techscribe],31,12))))

Sometimes it gives me an error and sometimes it will not even let me
preview
or run the report at all!

Any suggestions? Thanks in advance
Click to expand...
Click to expand...
 
Top