Table/Form Assistance.

[cybermonkey]

Ok, here's one I can't seem to get working how I want it to, and will try to explain it as best as I can.
I have table with only 3 fields. Name field which is chosen from a drop down list, type of call (also chosen from a drop down list) and a date/time field which is automatically filled in.
What I am trying to is build a form that lists the names pulled from the table, but only display them one time and then show next to them how many total entries in that table that name has.


I just can't seem to get it, any help/insight would be appreciated.

[isladogs]

Doesn't your table also have an autonumber primary key field?

Create an aggregate query and add the name field twice. The first should show GroupBy in the Totals row. The second instance should be changed to Count. Omit the other two table fields from the query