Count Records and get Average

jeo

Registered User.
Local time
Today, 10:12
Joined
Dec 26, 2002
Messages
299
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.
 
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
 
That Count(*) worked well, but how do I sum that one value for all records?
Something like Sum([Satisfied])
 
Count

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

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

That gives you the average instantly.

Trucktime
 
Thank you for all your help!
 

Users who are viewing this thread

Back
Top Bottom