calculates averages if not all questions are answered

[KevinS]

i have a form with 15 questions -- and each question may have multiple
replies. Under each question is the average for the number of responses. I
would like to calculate the overall average based on the number of responses.

To do this I have to examine the field to see if there was indeed a
response. Then divide by the number of hits by the average.

Background: This is a satisfaction survey for services provided to a family.
Each family member can respond to the question and see other members
responses.

Example: Q1 has three possible responders. Each response has a value from 1
- 5. If two people answer (respnder "A" pick 5, responder "B" picks 3) the
average would be 4. Q2 responder "A" chooses not to answer however responder
"B" picks 2 so the average would be 2.

This happens 15 times. The goal is an overall average.
Thank you for any help.

 

[Jeff Boyce]

There's no easy way to tell from your description if you are even using MS
Access (the topic of this newsgroup).

If you have something showing "the average for the number of responses" and
have it "under each question", how 'bout letting us know a bit more about
where/how? We aren't there. We can't see what you're looking at.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KevinS]

I am using Access 2000. Looking at the field I cannot figure out how the
last guy got it to average. I do not see any calculations in the table where
the field is listed not in the form itself. I even checked the builder -
nothing there.

the field is listed as a text field which surprised me.

 

[KARL DEWEY]

Check the query that pulls records from the table to display in the form.

 

[Jeff Boyce]

Kevin

Access is not Excel. You won't find "calculations in the table" (that's a
spreadsheet notion).

As Karl suggests, take a look at how the data gets from the table to the
form -- is the data source for the form the table directly or a query?

And in the form's design view, the control that's displaying the average ...
what does THAT control show for a data source?

And in the code-behind-the-form, are there any procedures running to
calculate and/or fill that control?

Regards

Jeff Boyce
Microsoft Office/Access MVP