 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2007Trying to get average of dollar values in one category of access.
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. Use a totals query and change Group By to Average.  SignatureKARL DEWEY Build a little - Test a little > 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. Thank you so much. Took seconds. > Use a totals query and change Group By to Average. > > > 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 SignatureDon''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.