Total Points Earned for Year

[Nick]

Note: This post is applicable in the Cloud database's Windows App as well as in the Legacy database.

Is there a report that will tell me ALL the points earned during the club year?  We are doing the AWANA store and each member has spent points.  I wanting to know ALL POINTS EARNED for club year.

[Rick Leffler]

Have you tried the Point List and Worksheet report?  This report is designed specifically for the Club Store. And, don't forget to use the Club Store module under Tools > Club Store to "spend" the points as recorded by the store clerk on the Point List and Worksheet printout.

As far as total points earned from a statistical perspective... try variations of the Achievement Report. (also under the Reports tab)

[Nick]

I've tried looking at the reports and can't find one that show total points earned for year.  I can find what points they have (running total)  but the total has been adjusted for points spend at store.  What I'm trying to do is see who earned the most points for the year in each group.  Is this a calculated number or is it store in a table that I might be able to access using SQL?

[dave4him]

Nick, look again at the Achievement Report, in the far right column under TOTAL POINTS. Just open your date range to the full year, using the start and end dates. See if that is what you are looking for.