Calculation of unbound

[Guest]

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

 

[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))))

 

[Guest]

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

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

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