Trying to get average of dollar values in one category of access.

[Eileen Price-Engram]

I have created three tables recording donations received, Donations, Large
Donations and Large Cash Donations. I now need to get the average of the
large cash donations. I've read the Builder 'help' section several times,
but can't get the expression right. Pls Advise.

 

[KARL DEWEY]

Use a totals query and change Group By to Average.

 

[Eileen Price-Engram]

Thank you so much. Took seconds.

Use a totals query and change Group By to Average.

 

[Dale Fye]

Eileen,

Are these (Donations, Large Donations, and Large Cash Donations) three
fields in your database, or do you have a DonationType field which contains
these as values, and then an Amount field that contains an amount?

I would think it would be better to structure your table with a PaymentType
(Cash, Check, Credit, ...) and an Amount field. Then, you could redefine
what Large means whenever you want and still query your databse to identify
contributors by any type/size donation.

HTH
Dale