count function on a report field is incorrect

[cmiyatake]

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?

[June7]

Exactly what is the expression used in textbox? If it is just bound to field in query then of course it will only show value from query, it is NOT doing a count on the report.

Expression in textbox either: Sum([fieldname]) or Count(*)

Alternatively, don't aggregate in query, do it on report. This allows display of detail records as well as summary calcs.

[cmiyatake]

Thanks. solved my problem. A slight difference in how to add a count field in a 2016 report vs what I have been used to. Got it now.

[June7]

How is it different?