Group By and then Count?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top