Hello,
I have a table with donations that I want to be able to:
1) group donations into specific campaigns denoted in a field called tracker
2) get total number of donations per tracking code { count(tracker) ?? }
3) get dollar total of all donations { sum(amount) ?? }
4) get an average donation from the preceding data { sum(amount) /
count(tracker) ?? }
I have, in addition to all the data about the donor, fields for amount and
tracker that would seem to be the only ones of concern here. I'm currently
doing this in a very ugly manner, and I just know that someone has a way to
do it with one SQL statement.
Thanks.
John Venable
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
