I have a query that is grouped by a field called "Survey Code". I need to find the sum of the values of a currency field ("Bill") for each entry in the "survey code" field. My query works perfectly if I have it set to "average", but the count field either displays the total number of records or another number thousands higher than it should be. The sum field displays the average value multiplied by the incorrect count field. I can't figure out how to filter the count/sum function so that it only includes appropriate values (like the average function seems to be doing). Any help would be appreciated. I'm kind of a newb at this.
Thanks
Nick