Count Records and get Average

[jeo]

Is there a way to count how many records you have in a form?
I have one filed on a form – “How satisfied were you” - field “Satisfied” and a client can enter from 1- 7. What I need is to add this “Satisfied” field up and then divide it by the number of projects to get an average.
Is this possible and if it is, could someone please tell me how.
I don’t know how I can count number of records on a form.
I’m also not sure if this should be done on a form or on a report?
Thanks.

 

[trucktime]

Put an unbound text box on you form and/or report and enter:

=Count(*)

That will count all of your records.

If your field Satisfied is a Number field you can Sum all values and divide it by the result of the Count Function in order to get the average.


Trucktime

 

[jeo]

That Count(*) worked well, but how do I sum that one value for all records?
Something like Sum([Satisfied])

 

[trucktime]

Count

Put the following in the control source of an unbound textbox:

=Sum([Satisfied])/Count(*)

That gives you the average instantly.

Trucktime

 

[jeo]

Thank you for all your help!

 

[trucktime]

Problem solved

You're welcome

Trucktime