Count of like fields

  • Thread starter Thread starter shoobootie
  • Start date Start date
S

shoobootie

This has to be an easy one, but still beyond me...

I want a report the will count how many of the same
account numbers there are in a table. I want a return
that shows something like this:

Account Count
619-0045 19
822-8855 4
900-3335 22

Obviously, I need the stupid instructions. I can follow,
but don't expect too much from me. Thanks!
 
Create a SELECT Query on the Table, bringing down Account Number twice into
the grid. Then, still in design view, on the menu, View | Totals. Choose
Group By under one occurrence of Account Number and Count under the other. I
think that will give you the information you want. Create the Report with
the Tabular report Wizard, on that Query.

Larry Linson
Microsoft Access MVP
 
Back
Top