Group By and then Count?

[Gary Dolliver]

Hi all,
I would like to perform a grouping on an Order_ID and then a Count on this
field. Is this possible? The control source is bringing in multiple records
for Order_ID, so when I place a Count on this field, it is incorrect. Is
there a way to do this in the report, or must it be done in the control
source?
Thanks!
-gary

 

[Duane Hookom]

You can build a totals query that counts your orders and results in a single
record. Add this query to your report's record source so you can add the
count field.