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

  • Thread starter Thread starter Eileen Price-Engram
  • Start date Start date
E

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.
 
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
 
Back
Top