Creating Year End Totals Report

[Gary Childress]

There must be an easy way to do this but I can't figure it out. All I want is a report that summarizes yearly totals from a query. I also need quarterly totals (but I'll worry about quarterly totals later for now). I don't need any other information on the report other than those totals.



I've started off with something like what is pictured below. Basically I created a form called "Yearly Stats Form". You type in a value for the year you want stats for on that form and it will give you both that year (using the query "Query Yearly Totals") and the prior year (using the query "Query Yearly Prior Totals"). Both queries are just simple queries from a table called "Main Events Table".

So far I've been able to successfully use DCount to total up the types of events in my report, however I'm having a problem figuring out how to total up two fields with numerical values. I tried to use the formula directly below in a text box on the report to sum up the total cost of attendance for the year:

=Sum([Query Yearly Totals]![Cost of Attendance])

However, when I run the report I get the following error code in the field: "#Error".

I also tried creating a "Totals" row at the bottom of the "Query Yearly Totals" query that sums up the total cost for the columns "Cost of Attendance" and "Attendance", however, I don't know how to get that total row to show on a report.

NOTE: the field "Cost of Attendance" is basically an "entry fee" for the event and the field "Attendance" is the number of people who attended the event. The total values of those two fields for the year are what I'm having trouble showing on the report.

Thank you.

[June7]

[Query Yearly Totals] is the RecordSource of the report?

If you want to provide db for analysis, follow instructions at bottom of my post.