I have a query that sets up my report wherein I also have grouped in the query a field as "Count". When I run the query, the field that is grouped has "1" in each corresponding field. Normal. When I go to the design mode of the report that is sourced by the query, I place the Count field in the report footer but the calculation is incorrect. When it should be 45 it is 1. What am I doing wrong? Should it not count each "1" associated with the count field and give me a total count of 45?